SELECT * FROM predmob_aircrafts WHERE manufacturer = 'EMBRAER' AND family = 'EMB'

Predictive Mobility > Aircrafts database > EMBRAER > EMB

Aircrafts in the family EMBRAER EMB

Here are the 4 aircrafts listed in the family EMB from the manufacturer Embraer with more technical data if provided.