Skip to content

AD 2011-21-07 R1

Registered aircraft · 910

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:2011-21-07-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:2011-21-07-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:2011-21-07-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:2011-21-07-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:2011-21-07-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:2011-21-07-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.

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 N613SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10038

Back to AD 2011-21-07 R1