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

Predictive Mobility > Aircrafts database > EMBRAER > EMJ

Aircrafts in the family EMBRAER EMJ

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