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.

N692AAAersale Inc · Doral, FLBuilt 1993 · S/N 26972N692DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29724N693DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29725N694ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26974N694DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29726N695DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29727N696ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26976N696DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29728N697ANBank Of Utah Trustee · Salt Lake City, UTBuilt 1994 · S/N 26977N697DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30318N69804United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42816N69806United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42742N69810United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42744N69813United Airlines Inc · Chicago, ILBuilt 2014 · S/N 43531N69816United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42176N69818United Airlines Inc · Chicago, ILFirst renewal noticeBuilt 2014 · S/N 42177N69819United Airlines Inc · Chicago, ILFirst renewal noticeBuilt 2014 · S/N 43533N69824United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42179N69826United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42180N69829United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44561N69830United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44560N69833United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44565N69835United Airlines Inc · Chicago, ILBuilt 2014 · S/N 60087N69838United Airlines Inc · Chicago, ILBuilt 2014 · S/N 60121N69839United Airlines Inc · Chicago, ILBuilt 2014 · S/N 60316N69840United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42181N69847United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42187N69885United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42189N69888United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42191N698DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29911N699DLDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29970N700KWEastern Airlines LLC · Kansas City, MOBuilt 1992 · S/N 25443N703ALAlaska Airlines Inc · Seattle, WABuilt 2023 · S/N 67426N703KWEastern Airlines LLC · Kansas City, MOBuilt 1991 · S/N 24343N704ALBca Customers Finance Inc · Renton, WABuilt 2023 · S/N 67501N705ALAlaska Airlines Inc · Seattle, WABuilt 2023 · S/N 67427N705KWEastern Airlines LLC · Kansas City, MOBuilt 1992 · S/N 24342N705TWDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28479N706ALAlaska Airlines Inc · Seatac, WABuilt 2023 · S/N 67502N706KWEastern Airlines LLC · Kansas City, MOBuilt 1990 · S/N 24339N707ALAlaska Airlines Inc · Seatac, WABuilt 2023 · S/N 67503N708ALAlaska Airlines Inc · Seattle, WABuilt 2023 · S/N 67801N708MBUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 30878N709ALBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 66365N710ALAlaska Airlines Inc · Seattle, WABuilt 2024 · S/N 67434N711ZXDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28481N712ALAlaska Airlines Inc · Seattle, WABuilt 2025 · S/N 67430N713ALAlaska Airlines Inc · Seattle, WABuilt 2024 · S/N 67433N71411United Airlines Inc · Chicago, ILBuilt 2002 · S/N 30128N716ALAlaska Airlines Inc · Seattle, WABuilt 2024 · S/N 67808
Back to AD 2018-20-13