Skip to content

Registered aircraft · 854

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:80-22-12-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:80-22-12-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:80-22-12-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:80-22-12-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:80-22-12-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:80-22-12-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.

N307ACBank Of Utah Trustee · Salt Lake City, UTS/N 30700 N309DEDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 29634 N309PCAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31258 N310DEDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 29665 N311GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 1995 · S/N 26316 N313XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25313 N314PDAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31259 N314XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25314 N3159GUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 35119 N315PEWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31261 N3160GUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 32277 N316PFAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31262 N317PGAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 33344 N318FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 28318 N325FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 28325 N326FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 28326 N326TRTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIS/N 20917 N330AEBank Of Utah Trustee · Salt Lake City, UTS/N 33007 N331CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1986 · S/N 23747 N33203United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30613 N33209United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30581 N33262United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32402 N33264United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31584 N33266United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32403 N33284Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 31635 N33286United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31600 N33289United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31607 N33292United Airlines Inc · Chicago, ILBuilt 2004 · S/N 33455 N33294Wells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2005 · S/N 34000 N332CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1987 · S/N 23707 N335PHAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31265 N33714United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28785 N337PJWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33345 N338PKWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31268 N339PLWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33346 N34222United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28931 N34282Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 31634 N342PMWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31269 N343PNWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31270 N344PPWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31272 N346PRWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31273 N3518JJetran LLC · Horseshoe Bay, TXS/N 35108 N35204United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30576 N35236United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28801 N35260United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30855 N35271United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31589 N352PSWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33256 N353PAAersale Inc · Coral Gables, FLS/N 20622 N354PTAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31275 N355PUAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 33348

Back to AD 80-22-12 R2