AD 2007-19-13

Registered aircraft · 2,446

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

N780BABoeing Aircraft Holding Co · Renton, WABuilt 1990 · S/N 24310N780UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26944N781ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29586N781UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 26945N78285Umb Bank N A Trustee · Salt Lake City, UTBuilt 2004 · S/N 33452N782ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30003N782UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26948N783ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30004N783AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 23016N783CKKalitta Air LLC · Ypsilanti, MIBuilt 1990 · S/N 24782N783HWSpectre Air Capital LLC · Horseshoe Bay, TXS/N 1817N783UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26950N784ANUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 29588N784JBJetblue Airways Corp · Long Island City, NYBuilt 2011 · S/N 4578N784UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26951N78501United Airlines Inc · Chicago, ILBuilt 2006 · S/N 31602N78506United Airlines Inc · Chicago, ILBuilt 2006 · S/N 32832N78509United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31638N78511United Airlines Inc · Chicago, ILBuilt 2008 · S/N 33459N78524United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31642N78540United Airlines Inc · Chicago, ILBuilt 2017 · S/N 63646N785ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30005N785UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26954N786ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30250N786UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26938N787ALAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30010N787CKKalitta Air LLC · Ypsilanti, MIBuilt 1997 · S/N 28838N787UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26939N788ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30011N788UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26942N789ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30252N789JBJetblue Airways Corp · Long Island, NYBuilt 2011 · S/N 4612N79011United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29859N790ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30251N791ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30254N791UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26933N79279United Airlines Inc · Chicago, ILBuilt 2003 · S/N 31597N792ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30253N792UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26934N793ACUmb Bank Na Trustee · Salt Lake City, UTS/N 30734N793ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30255N793AXAeroacq Partners LLC · Laud By Sea, FLS/N 23143N793JBJetblue Airways Corp · Long Island City, NYBuilt 2011 · S/N 4647N793UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26946N794ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30256N794JBJetblue Airways Corp · Long Island City, NYBuilt 2011 · S/N 4904N794UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26953N79521United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31662N79541United Airlines Inc · Chicago, ILBuilt 2017 · S/N 63725N795ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30257
Back to AD 2007-19-13