Skip to content

Registered aircraft · 501

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

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 N538CADelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15157 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 N547NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15317 N548CADelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15159 N548NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15318 N549CADelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15164 N549NNAmerican Airlines Inc · Fort Worth, TXS/N 15322 N550GJUnited Airlines Inc · Chicago, ILBuilt 2003 · S/N 10080 N550NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15323 N551NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15327 N552NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15328 N553NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15333 N554CADelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15168 N554NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15334 N555NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15338 N556NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15339 N557NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15340 N558NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15342 N559NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15343 N560NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15345 N561NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15346 N562NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 15347 N563NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15350 N564NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15351 N565NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15352 N566NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15353 N567NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15354 N568NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15355 N569NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15356 N570NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15357 N571NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15360 N572NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15361 N573NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15362 N574NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15365

Back to AD 2012-10-07