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.

N948ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30086 N948AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4933 N948FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25059 N948NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31189 N948TWKc Aviation Stem Inc · Kansas City, MOS/N 49575 N949ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29537 N949FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25060 N949NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31192 N950AMUmb Bank Na Owner Trustee · Salt Lake City, UTS/N 35115 N950ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30087 N950AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 3545 N950FDFederal Express Corp · Memphis, TNBuilt 1994 · S/N 25806 N950NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31194 N950NSCorsair Two LLC · Hillsboro, ORBuilt 1991 · S/N 53023 N951AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29538 N951AVWilmington Trust Company Trustee · Wilmington, DEBuilt 2008 · S/N 3574 N951BCJah2022a Saab340b Msn 318 LLC · Dallas, TXBuilt 1992 · S/N 340B-318 N951FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28665 N951NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 33327 N952AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30088 N952CAAc Spe 3 LLC · Orlando, FLBuilt 1991 · S/N 25238 N952FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28666 N952NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31196 N953ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29539 N953FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28667 N953JMAlta Airlines Holdings LLC · Salt Lake City, UTS/N 25151 N953NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33328 N954ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30089 N954AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 3699 N954FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 29113 N954NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31197 N955ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29540 N955AVWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 3835 N955FDFederal Express Corp · Memphis, TNBuilt 1998 · S/N 29114 N955NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31199 N956ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30090 N956AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6050 N956FDFederal Express Corp · Memphis, TNBuilt 1998 · S/N 29115 N956NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31200 N957AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 39957 N957ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29541 N957AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6057 N957NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31202 N958AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 39958 N958ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30091 N958AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6103 N958FDFederal Express Corp · Memphis, TNBuilt 1989 · S/N 24371 N958NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31203 N959ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30828 N959AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6110

Back to AD 74-08-09 R2