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.

N37700Delta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29631N3771KDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29632N3772HDelta Air Lines Inc · Atlanta, GABuilt 2010 · S/N 30823N3773DDelta Air Lines Inc · Atlanta, GABuilt 2010 · S/N 30825N377DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29625N377DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8856N377NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2082N378CXCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 27184N378DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30265N378DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8822N378HAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 1615N378NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 2092N379AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25200N379DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30349N379DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8914N379HAWells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2015 · S/N 1672N380ACUmb Bank Na Trustee · Salt Lake City, UTS/N 3383N380DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30266N380DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8915N380HAAelf Msn 1104 LLC · Chicago, ILBuilt 2010 · S/N 1104N381DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30350N381DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8859N381HAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 1114N38257United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30612N38268United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31587N382DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30345N382DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8854N382HAUmb Bank Na Trustee · Salt Lake City, UTBuilt 2010 · S/N 1171N383DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30346N383DZDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8916N383HAHawaiian Airlines Inc · Seattle, WABuilt 2011 · S/N 1217N384DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30347N384DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8974N384HAHawaiian Airlines Inc · Seattle, WABuilt 2011 · S/N 1259N385DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30348N385DZDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 8975N385HAHawaiian Airlines Inc · Seattle, WABuilt 2012 · S/N 1295N386DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30373N386DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8947N386HAAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 1302N387DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30374N387DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9025N388DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30375N388DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 9043N388HAAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 1310N389AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 26915N389DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30376N389DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 9057N389HABank Of Utah Trustee · Salt Lake City, UTS/N 1316N390CMCargo Aircraft Management Inc · Wilmington, OHBuilt 2002 · S/N 32973
Back to AD 2007-19-13