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.

N505AEAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 10053 N506AEAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 10056 N506CASkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7793 N507AEAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 10059 N507GJUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 10014 N508AEAmerican Airlines Inc · Fort Worth, TXBuilt 2002 · S/N 10072 N509AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10078 N510AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10105 N510SJN510sj LLC · Las Vegas, NVBuilt 2001 · S/N 7481 N511AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10107 N512AEAmerican Airlines Inc · Fort Worth, TXS/N 10110 N513AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10114 N513GJUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 10015 N514AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10119 N515AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10121 N515GJSkywest Leasing Inc · St George, UTS/N 10089 N516AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10123 N517AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10124 N518AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10126 N519AEAmerican Airlines Inc · Fort Worth, TXBuilt 2003 · S/N 10131 N519JGJoe Gibbs Racing LLC · Huntersville, NCBuilt 2005 · S/N 10217 N520DCAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10140 N520JGJoe Gibbs Racing LLC · Huntersville, NCBuilt 2002 · S/N 10052 N521AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10142 N522AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10147 N523AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10152 N524AEAmerican Airlines Inc · Fort Worth, TXBuilt 2004 · S/N 10154 N525AEAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10302 N526EAAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10304 N527EAAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10305 N527GJUnited Airlines Inc · Chicago, ILS/N 10004 N528EGAmerican Airlines Inc · Fort Worth, TXS/N 10306 N528GJUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 10031 N529EAAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10307 N530EAAmerican Airlines Inc · Fort Worth, TXBuilt 2010 · S/N 10308 N530JWBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 8109 N530SASlate Aircraft Company LLC · Johnstown, PAS/N 7985 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

Back to AD 2011-21-07 R1