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.

N660QXHorizon Air Industries Inc · Seatac, WABuilt 2023 · S/N 17000948 N661QXHorizon Air Industries Inc · Seattle, WABuilt 2023 · S/N 17000955 N662BTBeautech Power Systems LLC · Dallas, TXS/N 19000662 N662QXHorizon Air Industries Inc · Seattle, WABuilt 2023 · S/N 17000956 N663QXHorizon Air Industries Inc · Seattle, WABuilt 2024 · S/N 17000961 N664QXHorizon Air Industries Inc · Seattle, WABuilt 2024 · S/N 17000963 N665QXHorizon Air Industries Inc · Seattle, WABuilt 2024 · S/N 17000965 N667QXHorizon Air Industries Inc · Seatac, WABuilt 2025 · S/N 17000989 N668QXHorizon Air Industries Inc · Seatac, WAS/N 17000992 N669QXHorizon Air Industries Inc · Seattle, WAS/N 17000995 N670QXHorizon Air Industries Inc · Seatac, WAS/N 17001032 N671QXHorizon Air Industries Inc · Seatac, WAS/N 17001034 N672QXHorizon Air Industries Inc · Seatac, WAS/N 17001039 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 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

Back to AD 2008-08-21