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.

N364DXDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8530N364NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0962N364UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 33845N365DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 8536N365JSAelf Msn 242 LLC · Guaynabo, PRS/N 242N365NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0964N366CSCsds Asset Management LLC · Rllng Hls Est, CAS/N 366N366DXDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8694N366NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0981N367AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26912N367DNDelta Air Lines Inc · Altanta, GABuilt 2019 · S/N 8713N367NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0988N367SPSamaritan'S Purse · Boone, NCBuilt 2006 · S/N 33510N368DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8695N368NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 0996N369DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8697N369NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 1011N36NE2/25/94 LLC · Foxboro, MABuilt 1991 · S/N 25193N37018United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31680N370DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8765N370HAHawaiian Airlines Inc · Seattle, WABuilt 2014 · S/N 1511N370NWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 1037N371CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 25577N371DADelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29619N371DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8763N371NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1535N37252United 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 34004N372CMAirborne Maintenance And Engineering Serives Inc · Wilmington, OHBuilt 1992 · S/N 25575N372DADelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29620N372DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8809N372NWDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 1633N3730BDelta 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 30540
Back to AD 2007-19-13