Skip to content

Registered aircraft · 2,916

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:74-08-09-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:74-08-09-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:74-08-09-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:74-08-09-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:74-08-09-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:74-08-09-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.

N932NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33488 N932UPBoeing Co · Renton, WAS/N 70807 N933ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30080 N933NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31173 N933UPBoeing Co · Renton, WAS/N 70808 N934ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29531 N934NANational Aeronautics And Space Administration · Houston, TXS/N 47428 N934NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33489 N935ANAmerican Airlines Inc · Ft. Worth, TXBuilt 2000 · S/N 30081 N935CETatonduk Outfitters Ltd · Fairbanks, AKBuilt 1969 · S/N 47413 N935NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33231 N936ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29532 N936CAAc Spe 8 LLC · Orlando, FLBuilt 1991 · S/N 25308 N936NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31176 N937ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30082 N937NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31178 N938ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 29533 N938NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33490 N939ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 30083 N939AVAircol 24 · Wilmington, DEBuilt 2011 · S/N 4939 N939NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33491 N9405TFrontera Flight Holdings Inc · Dover, DES/N 53141 N9409FFronteraflight Holdings Inc · Dover, DEBuilt 1992 · S/N 53121 N940ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 30598 N940FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24772 N940NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33323 N941ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29534 N941ATBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1942 · S/N 12907 (42-93040)N941FDFederal Express Corp · Memphis, TNBuilt 1987 · S/N 22691 N941NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33232 N942ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30084 N942FDFederal Express Corp · Memphis, TNBuilt 1986 · S/N 22612 N942NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33492 N943ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30599 N943NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31177 N944ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29535 N944AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4730 N944NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31185 N945ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30085 N945AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4733 N945NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 33233 N945PKArchangel Operations LLC · Lewes, DEBuilt 1975 · S/N 165 N946ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30600 N946AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4924 N946FDFederal Express Corp · Memphis, TNS/N 24398 N946NANational Aeronautics And Space Administration · Houston, TXBuilt 1974 · S/N 146 N946NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 33234 N947ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29536 N947FDFederal Express Corp · Memphis, TNS/N 24882 N947NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31190

Back to AD 74-08-09 R2