Skip to content

AD 2005-13-02 R1

Registered aircraft · 493

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

N582CADelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15171 N582NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15385 N583GJUnited Airlines Inc · Chicago, ILBuilt 2002 · S/N 10048 N583NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15386 N584GJUnited Airlines Inc · Chicago, ILS/N 10130 N584NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15387 N585NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15388 N586NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15389 N587GJUnited Airlines Inc · Chicago, ILS/N 10270 N587NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15390 N588NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15391 N589NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15392 N590NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15393 N591CRBank Of Utah Trustee · Salt Lake City, UTS/N 15091 N591NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15394 N592NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15404 N593NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15405 N594NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15407 N595NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15408 N596NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15411 N597NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15412 N598NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15413 N599NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15415 N600LRDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15142 N600NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15416 N601ENAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 15462 N601LRDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15145 N602LRDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15151 N602NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 15463 N603NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 15464 N604LRDelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15152 N604NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 15465 N604SKSkywest Airlines Inc · St George, UTBuilt 2006 · S/N 10249 N605LRDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15160 N605NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 15467 N606LRDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15173 N606NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 15468 N606SKSkywest Airlines Inc · Saint George, UTBuilt 2006 · S/N 10250 N607LRDelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15178 N607NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 15471 N608NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 15473 N608SKSkywest Airlines Inc · Saint George, UTBuilt 2006 · S/N 10252 N609NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 15475 N609SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10020 N610NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 15476 N611NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 15460 N611SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10035 N612NNAmerican Airlines Inc · Fort Worth, TXBuilt 2019 · S/N 15477 N612QXSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10042 N613NNAmerican Airlines Inc · Fort Worth, TXBuilt 2020 · S/N 15481

Back to AD 2005-13-02 R1