Bombardier CL-600-2B16(CL-604)
Registered aircraft · 42
Aircraft of this model in the FAA registry, by N-number.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('1900314')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('1900314')
ORDER BY n_numberRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N101RERegistered aircraftN155ANBank Of Utah Trustee · Salt Lake City, UTN1821UBank Of Utah Trustee · Salt Lake City, UTN202ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN208QSRegistered aircraftN212CRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN214QSRegistered aircraftN21EJBank Of Utah Trustee · Salt Lake City, UTN237QSRegistered aircraftN240QSRegistered aircraftN241QSRegistered aircraftN242QSRegistered aircraftN252QSRegistered aircraftN2623World Air & Sea LLC · Northville, MIN304HEWater Capital LLC · Wilmington, DEN305MASc Aviation LLC · Miami, FLN317RARmc2 LLC · Boca Raton, FLN41HFFath Aviation Ltd · Cincinnati, OHN443QCBank Of Utah Trustee · Salt Lake City, UTN444KMPace Air LLC · Duluth, GAN4868Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN555ADAd One LLC · Mentor, OHN556CSLong Time Flyers LLC · Houston, TXN57ABRockwell Automation Inc · Milwaukee, WIN5950VZotec Transport Co LLC · Carmel, INN604XTJ Turbines Inc · Wilmington, DEN605BSStream Enterprises LLC · Marlborough, MAN605DATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN605GSGreystone Aircraft Holdings LLC · New York, NYN605JMMillrock Aviation Financial LLC · Danbury, CTN650CFTvpx Trust Co LLC Trustee · North Salt Lake, UTN650ELBank Of Utah Trustee · Salt Lake City, UTN650GKGekabi Aviation LLC · The Woodlands, TXN650HNTvpx Ars Inc Trustee · North Salt Lake, UTN683UFUnifirst Corp · Manchester, NHN69DTAir Dan LLC · Houston, TXN716JRHugo Enterprises LLC · Omaha, NEN798RSAriana LLC · Phoenix, AZN830CHWwbv Aviation LLC · Beachwood, OHN858CV28039 LLC · North Olmsted, OHN905SARegistered aircraftN949MCWolfpack Aviation LLC · Tysons, VA
Back to Bombardier CL-600-2B16(CL-604)