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.

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 N165SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000613 N166SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000615 N167SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000616 N168SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000617 N170EHHoneywell Aerospace US LLC · Phoenix, AZBuilt 2004 · S/N 17000059 N170SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000483

Back to AD 2008-08-21