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.

N603KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1985 · S/N 23213N60491Umb Bank Na Trustee · Salt Lake City, UTS/N 60491N604AABischoff Aerospace Inc · Doral, FLBuilt 1995 · S/N 27055N604KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1988 · S/N 24145N605KWAlta 767 Spv LLC · Salt Lake City, UTBuilt 1984 · S/N 23180N606AAStrategic Odyssey I LLC · Miami, FLFirst renewal noticeBuilt 1996 · S/N 27057N606KWAlta 767 Spv LLC · Salt Lake City, UTS/N 24324N607ASAlaska Airlines Inc · Seattle, WABuilt 1999 · S/N 29751N607AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30573N608DADelta Air Lines Inc · Atlanta, GABuilt 1985 · S/N 22815N60958Umb Bank Na Trustee · Salt Lake City, UTS/N 60958N609ASAlaska Airlines Inc · Seattle, WABuilt 1999 · S/N 29752N611ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 29753N612ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 30162N613ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 30163N613AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30574N614ASAlaska Airlines Inc · Seatac, WABuilt 1999 · S/N 30343N615ASAlaska Airlines Inc · Seatac, WABuilt 2000 · S/N 30344N617AZAmazon.Com Services LLC · Seattle, WABuilt 2001 · S/N 30575N61881United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42200N61882United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42201N61886United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42190N61887United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42192N61898United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62815N618ASAlaska Airlines Inc · Seatac, WABuilt 2000 · S/N 30543N619ASAlaska Airlines Inc · Seattle, WABuilt 2000 · S/N 30164N619AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30594N620DLAerotrust Services Corp Trustee · Wilmington, DEBuilt 1986 · S/N 22910N622ASAlaska Airlines Inc · Seattle, WABuilt 2000 · S/N 30165N625ASAlaska Airlines Inc · Seatac, WABuilt 2001 · S/N 30792N625HRTryst 767 LLC · San Juan, PRBuilt 1992 · S/N 25287N626ASAlaska Airlines Inc · Seatac, WABuilt 2001 · S/N 30793N626DSBoeing Co · Renton, WABuilt 2025 · S/N 68738N627ASAlaska Airlines Inc · Seattle, WABuilt 2001 · S/N 30794N62849United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42204N62883United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42202N62884United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42203N62889United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42193N62892United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42195N62894United Airlines Inc · Chicago, ILBuilt 2016 · S/N 42198N62895United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62769N62896United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62768N63820United Airlines Inc · Chicago, ILBuilt 2014 · S/N 43534N63890United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42194N63899United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62816N641AZAmazon.Com Services LLC · Seattle, WABuilt 2000 · S/N 30595N641UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25091N642UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25092N643AZAmazon.Com Services LLC · Seattle, WABuilt 2001 · S/N 32776N643UAUnited Airlines Inc · Chicago, ILBuilt 1991 · S/N 25093
Back to AD 2018-20-13