Skip to content

Registered aircraft · 688

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:2007-13-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-13-13') 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:2007-13-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-13-13')
  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:2007-13-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-13-13')
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.

N179SYSkywest Airlines Inc · Saint George, UTBuilt 2016 · S/N 17000565 N181SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000574 N182SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000579 N183SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000589 N184SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000590 N185SYSkywest Airlines Inc · Saint George, UTBuilt 2016 · S/N 17000600 N186SYSkywest Airlines Inc · Saint George, UTBuilt 2016 · S/N 17000606 N187SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000627 N188SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000628 N189SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000631 N191SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000632 N192SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000638 N193SYSkywest Airlines Inc · Saint George, UTBuilt 2017 · S/N 17000690 N194SYSkywest Airlines Inc · Saint George, UTBuilt 2017 · S/N 17000693 N195SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000698 N196SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000706 N197SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000709 N198SYSkywest Airlines Inc · St George, UTBuilt 2018 · S/N 17000724 N199SYSkywest Airlines Inc · Saint George, UTBuilt 2018 · S/N 17000730 N200NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000456 N200SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000623 N201JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000235 N201NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000461 N202JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000240 N202NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000467 N202SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000624 N203JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000242 N203NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000473 N203SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000625 N204JQRepublic Airways Inc · Carmel, INBuilt 2008 · S/N 17000243 N204NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 17000477 N204SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000626 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

Back to AD 2007-13-13