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.

N349DDAmerican Airlines Inc · Fort Worth, TXS/N 17001033 N350CDAmerican Airlines Inc · Fort Worth, TXS/N 17001036 N351SCAmerican Airlines Inc · Fort Worth, TXS/N 17001037 N352KRAmerican Airlines Inc · Fort Worth, TXS/N 17001040 N353EGAmerican Airlines Inc · Fort Worth, TXS/N 17001042 N354CGAmerican Airlines Inc · Fort Worth, TXS/N 17001043 N359EJRepublic Airways Inc · Carmel, INBuilt 2023 · S/N 17000359 N359MHAmerican Airlines Inc · Fort Worth, TXS/N 17001046 N360YFRegistered aircraftN-number assigned (import), not yet registeredS/N 17001049 N397NCWilmington Trust Company Trustee · Wilmington, DEBuilt 2008 · S/N 19000151 N400SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000732 N401YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000363 N402LBank Of Utah Trustee · Salt Lake City, UTS/N 19000585 N402SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000733 N402YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000364 N403SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000738 N403YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000365 N404SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000739 N404YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000367 N405SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000744 N405YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000368 N406SYSkywest Airlines Inc · St George, UTBuilt 2022 · S/N 17000900 N406YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000369 N407SYSkywest Airlines Inc · Saint George, UTBuilt 2022 · S/N 17000901 N407YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000370 N408SYSkywest Airlines Inc · St George, UTBuilt 2022 · S/N 17000902 N408YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000371 N409SYSkywest Airlines Inc · St George, UTBuilt 2022 · S/N 17000903 N409YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000372 N410SYSkywest Airlines Inc · Saint George, UTBuilt 2022 · S/N 17000904 N410YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000373 N411SYSkywest Airlines Inc · St George, UTBuilt 2022 · S/N 17000907 N411YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000374 N412SYSkywest Airlines Inc · St George, UTBuilt 2022 · S/N 17000908 N412YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000375 N413SYSkywest Airlines Inc · St George, UTBuilt 2022 · S/N 17000909 N413YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000376 N414SYSkywest Airlines Inc · St George, UTBuilt 2022 · S/N 17000910 N414YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000377 N415YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000378 N416YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000381 N417YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000382 N418YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000383 N419YXRepublic Airways Inc · Carmel, INBuilt 2013 · S/N 17000384 N420YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000385 N421YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000386 N422YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000387 N423YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000392 N424YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000393 N425YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000396

Back to AD 2008-08-21