Skip to content

Registered aircraft · 878

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.

N125SYSky West Airlines Inc · St George, UTBuilt 2014 · S/N 17000440 N126BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 19000124 N126HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000204 N127HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000206 N127SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000441 N128BZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 19000132 N128HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000208 N128SYSkywest Airlines Inc · St George, UTBuilt 2014 · S/N 17000445 N129HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000211 N130HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000212 N130SYSkywest Airlines Inc · Saint George, UTBuilt 2015 · S/N 17000449 N131HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000215 N131SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000450 N132HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000216 N132SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000451 N133ABBank Of Utah Trustee · Salt Lake City, UTS/N 19000469 N133HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000217 N133SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000452 N134HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000220 N134SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000458 N135HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000224 N135SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000460 N136HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000228 N136SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000462 N137HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000231 N138HQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000234 N138SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000466 N139SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000468 N140SYSkywest Airlines Inc · Saint George, UTBuilt 2015 · S/N 17000470 N141SYSkywest Airlines Inc · Saint George, UTBuilt 2015 · S/N 17000472 N142SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000475 N143BZPetrus Regional One Msn 19000276 LLC · Dallas, TXS/N 19000276 N143SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000476 N144SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000482 N145SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000484 N146SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000491 N148SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000492 N149SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000495 N150SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000499 N151SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000503 N152SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000549 N153SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000553 N154SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000556 N156SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000557 N157SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000558 N160SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000568 N161SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000569 N162SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000576 N163SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000577 N164SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000603

Back to AD 2020-07-21