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.

N571AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30388N57286United Airlines Inc · Chicago, ILBuilt 2022 · S/N 61854N57299Wilmington Trust Co Trustee · Wilmington, DEBuilt 2023 · S/N 67555N572LATagua Owner Trust · Wilmington, DEBuilt 2012 · S/N 41747N57409Wilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 68818N57416United Airlines Inc · Chicago, ILBuilt 2025 · S/N 67651N57439United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33534N57451Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67177N57466United Airlines Inc · Chicago, ILBuilt 2026 · S/N 67664N57478United Airlines Inc · Chicago, ILBuilt 2026 · S/N 67723N57480Wilmington Trust Co Trustee · Wilmington, DEBuilt 2026 · S/N 67677N57604Boeing Co · Renton, WAS/N 67687N577ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35186N57852United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32811N57855United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32814N57857United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32816N579ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35187N58101United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27291N581ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35188N581NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32982N582NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32981N583ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35681N583NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32983N584ASBank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35682N584NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32984N585ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35683N585NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32985N586ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35189N586NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32987N587ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35684N587NWDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 32986N588ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35685N588NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32988N589ASAlaska Airlines Inc · Seatac, WABuilt 2007 · S/N 35686N589NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32989N59053United Airlines Inc · Chicago, ILBuilt 2000 · S/N 29448N590ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35687N590NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32990N591NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32991N592ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35190N592NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32992N593ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35107N593NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32993N594ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35191N594NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32994N595NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32995N596ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35688N596NWDelta Air Lines Inc · Atlanta, GABuilt 2003 · S/N 32996N597ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35689N602KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1985 · S/N 23306
Back to AD 2018-20-13