AD 2018-20-13

Registered aircraft · 2,770

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:2018-20-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:2018-20-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.

N717TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 28485N718TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 28486N719ALAlaska Airlines Inc · Seattle, WABuilt 2024 · S/N 67807N720ALAlaska Airlines Inc · Seattle, WABuilt 2024 · S/N 67810N721TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29954N721VLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 34295N722ALAlaska Airlines Inc · Seatac, WABuilt 2024 · S/N 67809N722TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29385N723ALAlaska Airlines Inc · Seatac, WABuilt 2024 · S/N 67428N723TWDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 29378N72405United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30122N724ALAlaska Airlines Inc · Seattle, WABuilt 2024 · S/N 67429N724TWR&W Flying Inc · Greenbrier, ARS/N 28488N725ALAlaska Airlines Inc · Seattle, WABuilt 2025 · S/N 67431N727TWDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30340N729ALAlaska Airlines Inc · Seattle, WABuilt 2025 · S/N 67432N731ALAlaska Airlines Inc · Seatac, WABuilt 2025 · S/N 67811N73251United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30582N73256United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30611N73259United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30803N73270United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31632N73275United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31593N73276United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31594N73278United Airlines Inc · Chicago, ILBuilt 2003 · S/N 31596N73283Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 31606N73291Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 33454N73299United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34005N732ALAlaska Airlines Inc · Seatac, WABuilt 2025 · S/N 68520N733ALAlaska Airlines Inc · Seattle, WABuilt 2025 · S/N 67812N73406United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30123N73445United Airlines Inc · Chicago, ILBuilt 2011 · S/N 40000N734ALAlaska Airlines Inc · Seattle, WABuilt 2025 · S/N 68521N7378SRegistered aircraftBuilt 2021 · S/N 63431N738ALAlaska Airlines Inc · Seattle, WABuilt 2025 · S/N 68519N740AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22213N744AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22221N745AXCargo Aircraft Management Inc · Wilmington, OHS/N 22222N74856United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32815N749AX22226 Inc · Wilmington, DEBuilt 1984 · S/N 22226N750AXBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 22227N752AXAeroacq Partners LLC · Laud By Sea, FLS/N 23434N752CXCargo Aircraft Management Inc · Wilmington, OHS/N 24451N752LTL-3 Communications Advanced Aviation LLC · Kalispell, MTS/N 26058N75410United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30127N75425United Airlines Inc · Chicago, ILBuilt 2008 · S/N 33460N75426United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31622N75428United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31633N75429United Airlines Inc · Chicago, ILBuilt 2008 · S/N 30130N75432United Airlines Inc · Chicago, ILBuilt 2009 · S/N 32835N75433United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33527
Back to AD 2018-20-13