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.

N205JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000248 N205NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000481 N205SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000636 N206JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000249 N206NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000489 N206SYSkywest Airlines Inc · Saint George, UTBuilt 2017 · S/N 17000637 N207ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000490 N207JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000254 N207SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000643 N208ANAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000494 N208JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000257 N208SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000644 N209JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000258 N209NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000497 N209SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000645 N210JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000260 N210NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000500 N211JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000261 N211NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000501 N211SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000646 N212JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000264 N212NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000504 N213JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000265 N213NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000505 N213SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000666 N214JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000267 N214NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000508 N215JQRepublic Airways Inc · Carmel, INBuilt 2009 · S/N 17000270 N215NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000511 N216JQRepublic Airways Inc · Carmel, INBuilt 2009 · S/N 17000273 N216NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000513 N217JQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 17000171 N217NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000515 N218JQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 17000186 N218NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000519 N219NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000522 N219YXDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 17000188 N220JQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 17000195 N220NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000523 N221JQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 17000197 N221NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000525 N222JQDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 17000201 N222NSAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000528 N223JQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 17000207 N223NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000529 N223SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 17000223 N224JQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 17000209 N224NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 17000536 N224SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 17000232 N225JQDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 17000210

Back to AD 2008-08-21