Skip to content

Registered aircraft · 734

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:2008-08-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:2008-08-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:2008-08-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:2008-08-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:2008-08-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:2008-08-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.

N779RNWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000055 N779YXRepublic Airways Inc · Carmel, INBuilt 2025 · S/N 17000990 N780AHWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000131 N780NCCommuteair LLC · North Olmsted, OHBuilt 2009 · S/N 17000280 N780YXRepublic Airways Inc · Carmel, INS/N 17000991 N781EJWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000148 N781YXRepublic Airways Inc · Carmel, INBuilt 2025 · S/N 17000993 N782SMWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000022 N782YXRepublic Airways Inc · Carmel, INBuilt 2025 · S/N 17000994 N783LCWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000018 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 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 N82333United Airlines Inc · Chicago, ILBuilt 2015 · S/N 17000532 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 N84307United Airlines Inc · Chicago, ILBuilt 2014 · S/N 17000419 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 N855RWRepublic Airways Inc · Carmel, INBuilt 2005 · S/N 17000077

Back to AD 2008-08-21