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.

N614NNAmerican Airlines Inc · Fort Worth, TXBuilt 2020 · S/N 15483 N614QXSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10049 N614SKSkywest Airlines Inc · St George, UTBuilt 2002 · S/N 10051 N615NNAmerican Airlines Inc · Fort Worth, TXBuilt 2020 · S/N 15484 N616NNAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 15426 N617NNAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 15428 N618NNAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 15429 N619NNAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 15434 N621SASlate Aircraft Company LLC · Johnstown, PAS/N 7987 N625CASkywest Airlines Inc · St George, UTBuilt 2003 · S/N 10113 N629NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15373 N630NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15374 N630SKSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 10328 N631NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15375 N631SKSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 10329 N632NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15376 N632SKSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 10330 N633NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15377 N633SASlate Aircraft Company LLC · Johnstown, PAS/N 7988 N633SKSkywest Airlines Inc · St George, UTBuilt 2011 · S/N 10331 N634NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15378 N635NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15379 N636NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15399 N637NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15401 N638NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15402 N639NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15409 N640NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 15425 N641CADelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 10122 N641NNAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 15433 N642NNAmerican Airlines Inc · Fort Worth, TXS/N 15435 N643NNAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 15436 N644NNAmerican Airlines Inc · Fort Worth, TXS/N 15437 N645NNAmerican Airlines Inc · Fort Worth, TXS/N 15438 N646NNAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 15439 N647NNAmerican Airlines Inc · Fort Worth, TXS/N 15440 N648NNAmerican Airlines Inc · Fort Worth, TXS/N 15443 N649NNAmerican Airlines Inc · Fort Worth, TXBuilt 2018 · S/N 15444 N650RSSchumacher Oil LLC · Whitefish, MTS/N 7779 N655CADelta Air Lines Inc · Atlanta, GAS/N 10134 N659BRLogos Aviation Inc · Fort Lauderdale, FLBuilt 2001 · S/N 7509 N668CADelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 10162 N669CADelta Air Lines Inc · Atlanta, GABuilt 2004 · S/N 10176 N675BRLogos Aviation Inc · Fort Lauderdale, FLBuilt 2002 · S/N 7635 N676CADelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15127 N678CADelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15125 N679CADelta Air Lines Inc · Atlanta, GABuilt 2007 · S/N 15132 N679SASkywest Airlines Inc · St George, UTS/N 7652 N681SKSkywest Leasing Inc · St George, UTS/N 10036 N685BRBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 7712 N686BRBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 7715

Back to AD 2011-21-07 R1