Skip to content

Registered aircraft · 876

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:2020-07-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-07-21') 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:2020-07-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-07-21')
  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:2020-07-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2020-07-21')
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.

N783YXRepublic Airways Inc · Carmel, INS/N 17000997 N784DPWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000144 N784YXRepublic Airways Inc · Carmel, INS/N 17000998 N785BRWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000056 N785MMMirage Resorts LLC · Las Vegas, NVBuilt 2016 · S/N 19000709 N785YXRepublic Airways Inc · Carmel, INS/N 17001000 N786SMWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000052 N786YXRepublic Airways Inc · Carmel, INS/N 17001001 N787BPWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000046 N787YXRepublic Airways Inc · Carmel, INS/N 17001002 N788CJWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000051 N788YXRepublic Airways Inc · Carmel, INBuilt 2025 · S/N 17001009 N789SSWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000060 N789YXRepublic Airways Inc · Carmel, INS/N 17001011 N790MKWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000061 N790YXRepublic Airways Inc · Carmel, INS/N 17001015 N791DKWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000019 N791YXRepublic Airways Inc · Carmel, INS/N 17001022 N792JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000064 N792YXRepublic Airways Inc · Carmel, INS/N 17001023 N794JHWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000066 N798CCWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000070 N80343United Airlines Inc · Chicago, ILBuilt 2016 · S/N 17000571 N80348United Airlines Inc · Chicago, ILBuilt 2016 · S/N 17000599 N810MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 17000026 N815MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 17000034 N818MDUmb Bank Na Trustee · Salt Lake City, UTS/N 17000039 N82314United Airlines Inc · Chicago, ILBuilt 2014 · S/N 17000436 N82333United Airlines Inc · Chicago, ILBuilt 2015 · S/N 17000532 N82338United Airlines Inc · Chicago, ILBuilt 2016 · S/N 17000552 N82366United Airlines Inc · Chicago, ILBuilt 2020 · S/N 17000860 N823MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 17000044 N824MDUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 17000045 N825ACBank Of Utah Trustee · Salt Lake City, UTS/N 19000575 N827ACBank Of Utah Trustee · Salt Lake City, UTS/N 19000588 N83329United Airlines Inc · Chicago, ILBuilt 2015 · S/N 17000487 N84307United Airlines Inc · Chicago, ILBuilt 2014 · S/N 17000419 N84378United Airlines Inc · Chicago, ILBuilt 2021 · S/N 17000878 N85320United Airlines Inc · Chicago, ILBuilt 2015 · S/N 17000454 N85323United Airlines Inc · Chicago, ILBuilt 2015 · S/N 17000469 N85340United Airlines Inc · Chicago, ILBuilt 2016 · S/N 17000562 N85351United Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000672 N85352United Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000673 N85354United Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000687 N85355United Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000691 N85356United Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000692 N85358United Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000695 N85363United Airlines Inc · Chicago, ILBuilt 2020 · S/N 17000857 N85369United Airlines Inc · Chicago, ILBuilt 2020 · S/N 17000863 N85370United Airlines Inc · Chicago, ILBuilt 2020 · S/N 17000864

Back to AD 2020-07-21