SELECT * FROM predmob_aircrafts WHERE manufacturer = 'CANADAIR' AND family = 'CRJ'

Predictive Mobility > Aircrafts database > CANADAIR > CRJ

Aircrafts in the family CANADAIR CRJ

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