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.

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 N548DDModa Aviation LLC · Woodbury, NYBuilt 1997 · S/N 7176 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 N556SASlate Aircraft Company LLC · Johnstown, PAS/N 7983 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 N561AVWells Fargo Trust Co Na Trustee · Columbia, MDS/N 7561 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 N575NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15366 N576NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15367 N577GJUnited Airlines Inc · Chicago, ILBuilt 2006 · S/N 10262 N577NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15380 N578NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15381 N579NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15382 N580GJUnited Airlines Inc · Chicago, ILBuilt 2003 · S/N 10100 N580NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15383 N581GJUnited Airlines Inc · Chicago, ILBuilt 2005 · S/N 10205 N581NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 15384 N582CADelta Air Lines Inc · Atlanta, GABuilt 2008 · S/N 15171

Back to AD 2011-21-07 R1