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.

N397AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24035N397DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30537N397UPUnited Parcel Service Co · Louisville, KYBuilt 2010 · S/N 40363N398DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30774N399DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30379N3ERegistered aircraftBuilt 2021 · S/N 64084N402ASAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 41189N403ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 41730N407ASAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 41731N408ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 41732N409ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 41733N41135United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29284N41140United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30353N413ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 35205N413CMCargo Aircraft Management Inc · Wilmington, OHS/N 26988N418LACernicalo Leasing LLC · Wilmington, DEBuilt 2005 · S/N 34246N419ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 41734N419AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 26913N420LACaiquen Leasing LLC · Wilmington, DEBuilt 2006 · S/N 34627N423ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 35206N423AXOmni Planes LLC · Tulsa, OKBuilt 1996 · S/N 27569N428ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 36353N431ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 43255N431AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24632N432AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27449N433ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 41704N433AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24400N434ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 61620N435ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 43292N440ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 41705N442ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 43293N443AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25202N448ASAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 36356N453ASAlaska Airlines Inc · Seatac, WABuilt 2014 · S/N 36354N45440United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33535N455CMCargo Aircraft Management Inc · Wilmington, OHS/N 26983N457ASAlaska Airlines Inc · Seatac, WABuilt 2014 · S/N 36355N457AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 25448N459ASAlaska Airlines Inc · Seatac, WABuilt 2014 · S/N 36352N461ASAlaska Airlines Inc · Seattle, WABuilt 2014 · S/N 36363N462ASAlaska Airlines Inc · Seattle, WABuilt 2014 · S/N 36361N462CMN462cm Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 26985N464ASAlaska Airlines Inc · Seatac, WABuilt 2014 · S/N 40714N467ASAlaska Airlines Inc · Seatac, WABuilt 2014 · S/N 36362N468ASAlaska Airlines Inc · Seattle, WABuilt 2014 · S/N 41735N469AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 66372N469ASAlaska Airlines Inc · Seattle, WABuilt 2014 · S/N 41702N471ASAlaska Airlines Inc · Seattle, WABuilt 2014 · S/N 41703N471DSBoeing Co · Renton, WABuilt 2025 · S/N 68737N471TNUmb Bank Na Trustee · Salt Lake City, UTS/N 28837
Back to AD 2018-20-13