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.

N944NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31185 N945ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30085 N945NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 33233 N946ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30600 N946NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 33234 N947ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29536 N947NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31190 N948ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30086 N948NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31189 N949ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29537 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 N950NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31194 N951AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29538 N951NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 33327 N952AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30088 N952NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31196 N953ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29539 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 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 N960NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33330 N961ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30092 N961NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31205 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 N963ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29543 N963NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31208 N964ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30093 N964NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31210 N965ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29544 N965NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33239 N966ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30094 N966NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33240

Back to AD 80-22-12 R2