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.

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 N432YXRepublic Airways Inc · Carmel, INS/N 17000415 N433YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000417 N434YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000418 N435YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000423 N436YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000424 N437YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000366 N438YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000428 N439YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000434 N440YXRepublic Airways Inc · Carmel, INBuilt 2014 · S/N 17000435 N445YXRepublic Airways Inc · Carmel, INBuilt 2015 · S/N 17000455 N501SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000882 N502SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000883 N503SYSkywest Airlines Inc · Saint George, UTBuilt 2021 · S/N 17000884 N504SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000885 N505SYSkywest Airlines Inc · Saint George, UTBuilt 2021 · S/N 17000886 N506SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000887 N507SYSkywest Airlines Inc · Saint George, UTBuilt 2021 · S/N 17000888 N508SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000889 N509SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000890 N510SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000891 N511SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000892 N512SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000893 N513SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000894 N514SYSkywest Airlines Inc · Saint George, UTBuilt 2021 · S/N 17000895 N515SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000896 N516SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000897 N517SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000898 N519SYSkywest Airlines Inc · St George, UTBuilt 2021 · S/N 17000899 N520SYSkywest Airlines Inc · St George, UTBuilt 2022 · S/N 17000905 N521SYSkywest Airlines Inc · Saint George, UTBuilt 2022 · S/N 17000906 N529HGBank Of Utah Trustee · Salt Lake City, UTS/N 19000529 N536SYRegistered aircraftN-number assigned (import), not yet registeredS/N 17001048 N544SYRegistered aircraftN-number assigned (import), not yet registeredS/N 17001054 N545SYRegistered aircraftN-number assigned (import), not yet registeredS/N 17001055 N546SYRegistered aircraftN-number assigned (import), not yet registeredS/N 17001059 N556ELBank Of Utah Trustee · Salt Lake City, UTS/N 19000556 N603CZDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 17000176 N604CZDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 17000181 N607CZDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 17000192 N610CZDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 17000198 N613CZDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 17000203 N614CZDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 17000205

Back to AD 2008-08-21