Skip to content

Registered aircraft · 178

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:2016-17-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:2016-17-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:2016-17-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:2016-17-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:2016-17-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:2016-17-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.

N702SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10136 N703PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10137 N703SKSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 10139 N705PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10144 N705SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10145 N706PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10150 N706SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10149 N707SKSkywest Airlines Inc · St George, UTBuilt 1999 · S/N 10003 N708PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10160 N708SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10156 N709SKSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 10159 N710PSDougherty Air Trustee LLC Trustee · Minneapolis, MNBuilt 2004 · S/N 10167 N710SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10170 N712PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10168 N713SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10174 N715SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10179 N716PSUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 10171 N716SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10180 N718PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10175 N718SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10184 N719PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10177 N719SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10188 N720EVSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 10115 N720PSUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 10178 N722EVSkywest Airlines Inc · Saint George, UTBuilt 2003 · S/N 10127 N723PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10181 N724SKSkywest Airlines Inc · Saint George, UTBuilt 2004 · S/N 10189 N725PSAmerican Airlines Inc · Fort Worth, TXBuilt 2005 · S/N 10186 N726SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10190 N727SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10191 N728SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10192 N730EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10141 N730SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10193 N732SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10194 N740EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10151 N740SKSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 10196 N741EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10155 N742SKSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 10197 N744EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10157 N744SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10200 N745SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10201 N746SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10202 N748EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10158 N748SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10203 N750EVSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10161 N750SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10207 N751SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10208 N752EVSkywest Airlines Inc · St George, UTS/N 10166 N752SKSkywest Airlines Inc · Saint George, UTBuilt 2005 · S/N 10209 N753SKSkywest Airlines Inc · St George, UTBuilt 2005 · S/N 10214

Back to AD 2016-17-13