Skip to content

Registered aircraft · 1,336

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.

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 N954NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31197 N955ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29540 N955NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31199 N955VGTvpx Aircraft Solutions Trustee · North Salt Lake, UTBuilt 2002 · S/N 328 N956ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30090 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 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 N958NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31203 N959ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30828 N959BLRegistered aircraftN-number assigned (import), not yet registeredS/N 60959 N959NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33329 N960ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29542 N960CLDigital Interstate Management Inc · Keller, TXBuilt 1991 · S/N 094 N960NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33330 N9615WJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53562 N9616GJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53563 N9617RJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53564 N9618AJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53565 N9619VJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53566 N961ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30092 N961CEArctic One LLC · Fairbanks, AKBuilt 1987 · S/N 49470 N961NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31205 N961TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53611 N9620DJetran LLC · Horseshoe Bay, TXBuilt 1997 · S/N 53591 N9622AJetran LLC · Horseshoe Bay, TXBuilt 1998 · S/N 53593 N9624TJetran LLC · Horseshoe Bay, TXBuilt 1998 · S/N 53594 N9625WJetran LLC · Horseshoe Bay, TXBuilt 1998 · S/N 53595 N9626FJetran LLC · Horseshoe Bay, TXBuilt 1998 · S/N 53596 N9628WJetran LLC · Horseshoe Bay, TXBuilt 1998 · S/N 53598 N9629HJetran LLC · Horseshoe Bay, TXBuilt 1998 · S/N 53599 N962ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30858 N962BLRegistered aircraftN-number assigned (import), not yet registeredS/N 60962 N962NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 33331 N962TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53612 N963ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29543 N963CEArctic One LLC · Fairbanks, AKBuilt 1994 · S/N 53450 N963NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31208 N963TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53613 N964ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30093 N964CEArctic One LLC · Fairbanks, AKBuilt 1992 · S/N 53078 N964NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31210 N964TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53614 N965ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29544

Back to AD 99-23-22 R2