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.

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 N426YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000397 N427YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000402 N428YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000403 N429YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000408 N430SYSkywest Airlines Inc · St George, UTBuilt 2022 · S/N 17000911 N430YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000409 N431SYSkywest Airlines Inc · St George, UTS/N 17001025 N431YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000413

Back to AD 2020-07-21