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.

N528GJUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 10031 N529EAAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10307 N530EAAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10308 N531EGAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10309 N532EAAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10310 N533AEAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10311 N534AEAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10312 N535EAAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10313 N536EAAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10315 N537EAAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10316 N538EGAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10317 N539EAAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10318 N540EGAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 10319 N541EAAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 10320 N542EAAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 10321 N543EAAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 10323 N544EAAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 10324 N545PBAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 10325 N546FFAmerican Airlines Inc · Fort Worth, TXBuilt 2011 · S/N 10326 N550GJUnited Airlines Inc · Chicago, ILBuilt 2003 · S/N 10080 N577GJUnited Airlines Inc · Chicago, ILBuilt 2006 · S/N 10262 N580GJUnited Airlines Inc · Chicago, ILBuilt 2003 · S/N 10100 N581GJUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 10205 N583GJUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 10048 N584GJUnited Airlines Inc · Chicago, ILS/N 10130 N587GJUnited Airlines Inc · Chicago, ILS/N 10270 N604SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 10249 N606SKSkywest Airlines Inc · Saint George, UTBuilt 2006 · S/N 10250 N608SKSkywest Airlines Inc · Saint George, UTBuilt 2006 · S/N 10252 N609SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10020 N611SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10035 N612QXSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10042 N613SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10038 N614QXSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10049 N614SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10051 N625CASkywest Airlines Inc · St George, UTBuilt 2003 · S/N 10113 N630SKSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 10328 N631SKSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 10329 N632SKSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 10330 N633SKSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 10331 N641CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10122 N655CADelta Air Lines Inc · Atlanta, GAS/N 10134 N668CADelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 10162 N669CADelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 10176 N681SKSkywest Leasing Inc · St George, UTS/N 10036 N686SKSkywest Leasing Inc · St George, UTS/N 10096 N690CADelta Air Lines Inc · Atlanta, GAS/N 10182 N690SKSkywest Leasing Inc · St George, UTS/N 10264 N701SKSkywest Airlines Inc · St George, UTBuilt 2004 · S/N 10133 N702PSAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10135

Back to AD 2016-17-13