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.

N674DLDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 25979N674UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 29242N67501United Airlines Inc · Chicago, ILBuilt 2018 · S/N 43430N675UAUnited Airlines Inc · Chicago, ILBuilt 2000 · S/N 29243N67603Boeing Co · Renton, WAS/N 43502N676DLDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 25981N676UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30028N677UAUnited Airlines Inc · Chicago, ILBuilt 2001 · S/N 30029N67812United Airlines Inc · Chicago, ILBuilt 2014 · S/N 43530N67815United Airlines Inc · Chicago, ILBuilt 2014 · S/N 43532N67827United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44581N67845United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42185N67846United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42186N678DLDelta Air Lines Inc · Atlanta, GABuilt 1992 · S/N 25983N68061United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29456N68084Federal Express Corp · Memphis, TNS/N 25036N68085Federal Express Corp · Memphis, TNBuilt 1993 · S/N 26702N68087Federal Express Corp · Memphis, TNBuilt 1990 · S/N 24891N681AABank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 25338N682DADelta Air Lines Inc · Atlanta, GAFirst renewal noticeBuilt 1993 · S/N 26958N683AZAmazon.Com Services LLC · Seattle, WABuilt 2022 · S/N 67027N683DADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 27103N68452United Airlines Inc · Chicago, ILBuilt 2012 · S/N 40005N68453United Airlines Inc · Chicago, ILBuilt 2012 · S/N 41742N684DADelta Air Lines Inc · Atlanta, GABuilt 1993 · S/N 27104N685DADelta Air Lines Inc · Atlanta, GABuilt 1995 · S/N 27588N686AABank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 25343N686DADelta Air Lines Inc · Atlanta, GABuilt 1995 · S/N 27589N687DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 27586N68801United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42740N68802United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42739N68805United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42818N68807United Airlines Inc · Chicago, ILBuilt 2013 · S/N 42819N68811United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42175N68817United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42747N68821United Airlines Inc · Chicago, ILBuilt 2014 · S/N 43535N68822United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42178N68823United Airlines Inc · Chicago, ILBuilt 2014 · S/N 42746N68834United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44564N68836United Airlines Inc · Chicago, ILBuilt 2014 · S/N 60088N68842United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42183N68843United Airlines Inc · Chicago, ILBuilt 2015 · S/N 60317N68880United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42199N68891United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42196N688DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 27587N688SLAero Micronesia Inc DBA · Barrigada, GUBuilt 1991 · S/N 25140N689DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 27172N69059United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29454N69063United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29458N690DLDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 27585
Back to AD 2018-20-13