AD 75-05-01

Registered aircraft · 920

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

N281FLInternational Trading Co Of Yukon · Oklahoma City, OKBuilt 1978 · S/N 21455N289MTRaytheon Co · Ontario, CABuilt 1981 · S/N 22467N290FAUmb Bank N A Trustee · Salt Lake City, UTS/N 29080N29717United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28936N301KHAeko Kula LLC DBA · Honolulu, HIBuilt 1995 · S/N 27904N301NWAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33342N301PAAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31255N302FLBank Of Utah Trustee · Salt Lake City, UTS/N 30072N303KHNas Aircraft Leasing Company LLC · Anchorage, AKBuilt 1999 · S/N 25606N303TWLogistic Air Inc · Reno, NVS/N 20116N305NXAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31253N306NYAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33343N306PBAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31257N307ACBank Of Utah Trustee · Salt Lake City, UTS/N 30700N309DEDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 29634N309PCAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31258N310DEDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 29665N311GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 1995 · S/N 26316N313XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25313N314PDAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31259N314XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25314N3159GUmb Bank Na Trustee · Salt Lake City, UTBuilt 2007 · S/N 35119N315PEWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31261N3160GUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 32277N316PFAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31262N317PGAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 33344N318FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 28318N322SGAtlas Air Inc · Purchase, NYBuilt 2000 · S/N 30322N325FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 28325N326FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 28326N326TRTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIS/N 20917N329ZAKalitta Air LLC · Ypsilanti, MIBuilt 2003 · S/N 32914N330AEBank Of Utah Trustee · Salt Lake City, UTS/N 33007N331CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1986 · S/N 23747N33203United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30613N33209United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30581N33262United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32402N33264United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31584N33266United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32403N33284Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 31635N33286United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31600N33289United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31607N33292United Airlines Inc · Chicago, ILBuilt 2004 · S/N 33455N33294Wells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2005 · S/N 34000N332CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1987 · S/N 23707N335PHAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31265N33714United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28785N337JXJetonex LLC · Sunny Isles Beach, FLS/N 33734N337PJWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33345N338PKWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31268
Back to AD 75-05-01