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.

N344PPWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31272N344TSAmerican Airlines Inc · Fort Worth, TXBuilt 2024 · S/N 44491N346PRWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31273N347AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1994 · S/N 26264N347CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26995N347TTAmerican Airlines Inc · Fort Worth, TXBuilt 2024 · S/N 44489N348TUAmerican Airlines Inc · Fort Worth, TXBuilt 2024 · S/N 44492N349CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26996N349TVAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 44493N350RVWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 44462N3518JJetran LLC · Horseshoe Bay, TXS/N 35108N351CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25201N35204United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30576N35236United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28801N35260United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30855N35271United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31589N352PSWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33256N353AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25198N35407United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30124N354PTAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31275N355PUAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 33348N355TWAmerican Airlines Inc · Fort Worth, TXBuilt 2024 · S/N 44496N356TXAmerican Airlines Inc · Fort Worth, TXBuilt 2024 · S/N 44494N357PVWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 31277N357TYAmerican Airlines Inc · Fort Worth, TXBuilt 2024 · S/N 44505N358PWWilmington Trust Co Trustee · Wilmington, DEBuilt 2017 · S/N 33349N359AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24036N359PXAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31280N36207United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30579N36247United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28807N36272United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31590N36280United Airlines Inc · Chicago, ILBuilt 2003 · S/N 31598N362CMCargo Aircraft Management Inc · Wilmington, OHS/N 24316N362UPUnited Parcel Service Co · Louisville, KYS/N 33493N363CMCargo Aircraft Management Inc · Wilmington, OHS/N 24853N363UPUnited Parcel Service Co · Louisville, KYBuilt 2003 · S/N 33494N36444United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31643N36447United Airlines Inc · Chicago, ILBuilt 2012 · S/N 31650N36469United Airlines Inc · Chicago, ILBuilt 2013 · S/N 36600N36472United Airlines Inc · Chicago, ILBuilt 2013 · S/N 31653N36476United Airlines Inc · Chicago, ILBuilt 2013 · S/N 38703N364CMCargo Aircraft Management Inc · Wilmington, OHS/N 24531N364UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 33845N365UPCc & E I LLC · Louisville, KYBuilt 2019 · S/N 65788N366UPC C & E I LLC · Louisville, KYBuilt 2019 · S/N 65789N367AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 26912N367SPSamaritan'S Purse · Boone, NCBuilt 2006 · S/N 33510N367UPC C & E I LLC · Louisville, KYBuilt 2019 · S/N 65790N368AMBank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 66301N368UPC C & E I LLC · Louisville, KYBuilt 2019 · S/N 65907
Back to AD 2018-20-13