AD 2012-19-11

Registered aircraft · 1,183

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

N36444United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31643N36447United Airlines Inc · Chicago, ILBuilt 2012 · S/N 31650N36469United Airlines Inc · Chicago, ILBuilt 2013 · S/N 36600N36472United Airlines Inc · Chicago, ILBuilt 2013 · S/N 31653N36476United Airlines Inc · Chicago, ILBuilt 2013 · S/N 38703N370BCBcm Majestic Corp · Dallas, TXBuilt 1986 · S/N 23468N371DADelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29619N37252United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30583N37253United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30584N37255United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30610N37263United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31583N37267United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31586N37273United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31591N37274United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31592N37277United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31595N37281United Airlines Inc · Chicago, ILBuilt 2003 · S/N 31599N37287United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31636N37290United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31601N37293Bank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 33453N37298United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34004N372DADelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29620N3730BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30538N3731TDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30775N3732JDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30380N3733ZDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30539N3734BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30776N3735DDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30381N3736CDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30540N3737CDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30799N3738BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30382N3739PDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30541N373DADelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29621N37408United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30125N37409United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30126N3740CDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30800N37413United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31664N37419United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31666N3741SDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30487N37420United Airlines Inc · Chicago, ILBuilt 2008 · S/N 33457N37422United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31620N37427United Airlines Inc · Chicago, ILBuilt 2008 · S/N 37097N3742CDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30835N37434United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33528N37437United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33532N3743HDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30836N3744FDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30837N37456United Airlines Inc · Chicago, ILBuilt 2012 · S/N 37205N3745BDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 32373N37462United Airlines Inc · Chicago, ILBuilt 2012 · S/N 37207N37464United Airlines Inc · Chicago, ILBuilt 2012 · S/N 41745
Back to AD 2012-19-11