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.

N170XYSwiflite Aircraft Corp · Houston, TXBuilt 2008 · S/N 17000241 N171SYSkywest Airlines Inc · Saint George, UTBuilt 2015 · S/N 17000485 N173SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000486 N174SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000517 N175RSAng USA III LLC · Naples, FLBuilt 2006 · S/N 17000141 N175SYSkywest Airlines Inc · St George, UTBuilt 2015 · S/N 17000527 N176RSAng USA I LLC · Naples, FLBuilt 2005 · S/N 17000107 N176SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000533 N177RSAng USA II LLC · Naples, FLBuilt 2006 · S/N 17000112 N177SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000535 N178SYSkywest Airlines Inc · St George, UTBuilt 2016 · S/N 17000555 N179RSAng USA IV LLC · Naples, FLS/N 17000146 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 N184JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 19000008 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 N190JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 19000011 N190MBBank Of Utah Trustee · Salt Lake City, UTS/N 19000524 N191SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000632 N192JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 19000014 N192SYSkywest Airlines Inc · St George, UTBuilt 2017 · S/N 17000638 N193JBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 19000017 N193SYSkywest Airlines Inc · Saint George, UTBuilt 2017 · S/N 17000690 N194SYSkywest Airlines Inc · Saint George, UTBuilt 2017 · S/N 17000693 N195ARBank Of Utah Trustee · Salt Lake City, UTS/N 19000154 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

Back to AD 2008-08-21