Skip to content

Registered aircraft · 1,335

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:99-23-22-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-23-22-R2') 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:99-23-22-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-23-22-R2')
  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:99-23-22-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-23-22-R2')
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.

N828AHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 415 N829NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33210 N829WWHemisphere Aerospace Investments LLC · Waco, TXS/N 27503 N82BULacore Adventures LLC · Melissa, TXBuilt 1988 · S/N 51 N830DMWord Of Life World Outreach Center Inc DBA · Murrieta, CABuilt 1991 · S/N 222 N830NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31091 N831NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33211 N832NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 33521 N833NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 31093 N834NNAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 29576 N835NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 29577 N836NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31095 N837NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30908 N838NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31097 N839ACBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N E2270 N839NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29557 N839SYBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 42083 N83TYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 288 N840NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 33518 N840SYBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 42084 N841NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30914 N842NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31099 N843NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30906 N844NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 33212 N845AMWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2014 · S/N 36706 N845NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40579 N846NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31101 N847NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29575 N848NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31103 N849NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 33213 N8501VSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 41530 N8502ZSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 36666 N8503ASouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 38813 N8504GSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 38812 N8507CSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 41531 N8508WSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 38814 N8509USouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 36925 N850ENBcbg Capital LLC · Clearwater, FLBuilt 2002 · S/N 326 N850FJPachy Music Corp · Bellflower, CABuilt 1991 · S/N 215 N850NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40580 N8510ESouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 36944 N8511KSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 36670 N8512USouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 38816 N8513FSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 36976 N8514FSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 36975 N8515XSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 36943 N8517FSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 63594 N8518RSouthwest Airlines Co · Dallas, TXBuilt 2016 · S/N 63593 N8519RSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 36910 N851NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29556

Back to AD 99-23-22 R2