Skip to content

Registered aircraft · 702

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-11-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-11-21') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-11-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-11-21')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-11-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-11-21')
ORDER BY n_number

Run 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.

N841DSCobalt Aero LLC · Albany, GABuilt 2007 · S/N 40.881 N845MAN845ma Aircraft Leasing LLC · Lehi, UTS/N 40.345 N8482XRegistered aircraftBuilt 2016 · S/N 40.839 N850DSR&I Dry Willow LLC · Payson, UTBuilt 2007 · S/N 40.750 N853BCAtis Aero LLC · Fort Myers, FLBuilt 2008 · S/N 40.919 N854AKAraki Satoshi · Hayward, CABuilt 2005 · S/N 40.528 N856DSInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 40.756 N858DTUtah State University · Logan, UTS/N 40.748 N858PAPodhajsky Nicholas P · Traer, IAS/N 40.258 N859PABuelna Manuel Jr · Summerville, SCS/N 40.264 N866DSSiteserver Inc · Bend, ORBuilt 2007 · S/N 40.766 N866USUtah State University · Logan, UTBuilt 2007 · S/N 40.866 N867DSStarboard Light Aviation LLC · Dover, DES/N 40.867 N868EAtlas Aircrafts LLC · Coral Springs, FLBuilt 2005 · S/N 40.569 N868USMel Aviation LLC · Johns Creek, GABuilt 2007 · S/N 40.868 N870BREva Flight Training Academy · Mather, CABuilt 2013 · S/N 40.1187 N871BREva Flight Training Academy · Mather, CABuilt 2013 · S/N 40.1190 N871DSDesota LLC · Marion, ILBuilt 2007 · S/N 40.801 N872BREva Flight Training Academy · Mather, CABuilt 2014 · S/N 40.1197 N873BREva Flight Training Academy · Mather, CABuilt 2014 · S/N 40.1198 N873MAChucktown Flight Training LLC · North Charleston, SCBuilt 2007 · S/N 40.883 N875BREva Flight Training Academy · Mather, CABuilt 2014 · S/N 40.1199 N876BREva Flight Training Academy · Mather, CABuilt 2015 · S/N 40.1200 N877BREva Flight Training Academy · Mather, CABuilt 2015 · S/N 40.1201 N877USTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2007 · S/N 40.877 N878BREva Flight Training Academy · Mather, CABuilt 2025 · S/N 40.1263 N879BREva Flight Training Academy · Mather, CABuilt 2025 · S/N 40.1264 N880DS4r Aero LLC · Bozeman, MTBuilt 2007 · S/N 40.887 N881UJBurke Farm Management Service Inc · Waynesboro, GABuilt 2006 · S/N 40.649 N881WGots To Go LLC · Wilmington, DEBuilt 2005 · S/N 40.550 N882DSWeiner Keith Randall · Mission Viejo, CABuilt 2008 · S/N 40.882 N884USVuksanovic David A · Fountain Hills, AZBuilt 2007 · S/N 40.884 N885USPacific Gold Aviation Association Inc · Roseville, CABuilt 2007 · S/N 40.885 N886KCForte Adam · Rochester Hills, MIBuilt 2007 · S/N 40.886 N888YWJoerithan & Mp Aviation LLC · Whittier, CABuilt 2006 · S/N 40.689 N889DSTeton Avjet LLC · Driggs, IDBuilt 2007 · S/N 40.889 N890USReina Orestes Esteban · Coral Springs, FLBuilt 2008 · S/N 40.890 N892DSR & K Designs LLC · Wake Forest, NCBuilt 2007 · S/N 40.892 N893DSNorton Boe L Trustee · Carlsbad, NMBuilt 2006 · S/N 40.743 N894AMFleser Carl R · Sunbury, OHBuilt 2007 · S/N 40.794 N894DSWallis Steel C · Las Vegas, NVBuilt 2006 · S/N 40.744 N894SAUtah State University · Logan, UTBuilt 2007 · S/N 40.759 N895AMMeng Ye · Irvine, CABuilt 2008 · S/N 40.895 N896AMErikson Diversified Industries Inc · Spotsylvania, VABuilt 2008 · S/N 40.896 N896NKInkenbrandt Consulting LLC · San Francisco, CABuilt 2007 · S/N 40.792 N899DSSommer Leroy V · Cheverly, MDBuilt 2008 · S/N 40.899 N8VTAleph Leasing LLC · Eagle Mountain, UTBuilt 2005 · S/N 40.480 N900DAMurray Dennis E · Colorado Springs, COBuilt 2005 · S/N 40.590 N902DSMount Daufuskie Charters Inc · Greenwich, CTBuilt 2008 · S/N 40.982 N902MRJoerithan & Mp Aviation LLC · Whittier, CAS/N 40.324

Back to AD 2007-11-21