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.

N560DSBug Smasher Aviation LLC · Boston, MABuilt 2007 · S/N 40.860 N563DSProaero LLC · Florence, SCBuilt 2007 · S/N 40.863 N563MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2025 · S/N 40.1257 N564MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.300 N565DS5ds Leasing LLC · Englewood, COBuilt 2006 · S/N 40.645 N565MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.301 N566MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.304 N567MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.308 N568CAOncore Aviation LLC · Rochester, NYBuilt 2006 · S/N 40.711 N568MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.312 N569DSCapitol City Flyers Inc · Madison, WIBuilt 2006 · S/N 40.648 N569MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.314 N570MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.363 N571DSBcd Leasing Corp · Lexington, KYBuilt 2005 · S/N 40.571 N571MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.396 N572DSFort Wayne Aircraft LLC · Fort Wayne, INBuilt 2007 · S/N 40.857 N572MTMiddle Tennessee State University · Murfreesboro, TNS/N 40.577 N578KSMisurelli Francis X · Lake Hopatcong, NJBuilt 2004 · S/N 40.429 N57PUEight Ball Flying Club · Van Nuys, CAFirst renewal noticeBuilt 2002 · S/N 40.214 N581MTMiddle Tennessee State University · Murfressboro, TNBuilt 2004 · S/N 40.397 N582MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.398 N583MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.399 N584MTMiddle Tennessee State Univ · Murfreesboro, TNBuilt 2008 · S/N 40.952 N585BWNew Horizon Aviation LLC · Medford, NJS/N 40.262 N585MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2008 · S/N 40.958 N586MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2008 · S/N 40.962 N587MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2008 · S/N 40.971 N588MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2008 · S/N 40.974 N589MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2008 · S/N 40.978 N589TFam Vans Inc · Fountain Valley, CAS/N 40.503 N590MTMiddle Tennessee State University · Murfreesboro, TNS/N 40.980 N591CAMountain Air Estates LLC · Yakima, WABuilt 2007 · S/N 40.862 N592CAOncore Aviation LLC · Rochester, NYBuilt 2006 · S/N 40.729 N592MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2008 · S/N 40.981 N593MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2025 · S/N 40.1258 N594MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2020 · S/N 40.1211 N595MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2020 · S/N 40.1212 N596MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2020 · S/N 40.1213 N597MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2020 · S/N 40.1215 N597RARedtail Aviation LLC · Brookville, PABuilt 2004 · S/N 40.444 N598MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2020 · S/N 40.1226 N599MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2020 · S/N 40.1227 N59GAFlesberg Allan J · Olathe, KSBuilt 2002 · S/N 40.243 N5WUDiamond West LLC · Walnut Creek, CABuilt 2004 · S/N 40.400 N605BGAir Carriage Inc · Chico, CABuilt 2005 · S/N 40.566 N605CAUtah State University · Logan, UTBuilt 2008 · S/N 40.911 N607DSNasir Rehan S · Lancaster, PABuilt 2002 · S/N 40.207 N607MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2026 · S/N 40.1259 N608DSJoerithan & Mp Aviation LLC · Whittier, CABuilt 2002 · S/N 40.217 N609CAEkko Flight LLC · Middlebury, CTBuilt 2007 · S/N 40.869

Back to AD 2007-11-21