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.

N702SYSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 17000029 N703SYSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 17000010 N705SYSkywest Airlines Inc · St George, UTBuilt 2008 · S/N 17000065 N706SYSkywest Airlines Inc · St George, UTS/N 17000035 N709AJBank Of Utah Trustee · Salt Lake City, UTS/N 19000313 N709SYSkywest Airlines Inc · Saint George, UTS/N 17000074 N713TSCactus Jack Airlines LLC · Beverly Hills, CABuilt 2015 · S/N 19000632 N721YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000493 N722YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000496 N723YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000498 N724YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000502 N725YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000506 N726YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000507 N727YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000509 N728YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000510 N729YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000512 N730YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000518 N731SYSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 17000009 N731YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000520 N732SYSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 17000011 N732YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000521 N733YXRepublic Airways Inc · Carmel, INBuilt 2016 · S/N 17000539 N736YXRepublic Airways Inc · Carmel, INBuilt 2016 · S/N 17000541 N739AEWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000080 N739YXRepublic Airways Inc · Carmel, INBuilt 2016 · S/N 17000542 N740MRWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000082 N740YXRepublic Airways Inc · Carmel, INBuilt 2016 · S/N 17000544 N741AKWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000138 N741YXUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000653 N742GRWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000140 N742YXUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000654 N743MBWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000143 N743YXUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000660 N744DBWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 17000130 N744YXUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000661 N745JBWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000071 N745YXUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000670 N746CCWilmington Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 17000042 N746YXUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000671 N747YXUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000676 N748RRWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000072 N748YXUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000677 N749BMWilmington Trust Company Trustee · Wilmington, DEBuilt 2006 · S/N 17000133 N749YXUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000685 N750BDWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000075 N750YXUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000686 N751ABWilmington Trust Co Trustee · Wilmington, DEBuilt 2005 · S/N 17000078 N751YXUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000688 N752YXUnited Airlines Inc · Chicago, ILBuilt 2017 · S/N 17000689 N753YXRepublic Airways Inc · Carmel, INBuilt 2022 · S/N 17000924

Back to AD 2020-07-21