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.

N958FDFederal Express Corp · Memphis, TNBuilt 1989 · S/N 24371N958NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31203N959AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 68131N959ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30828N959BLRegistered aircraftN-number assigned (import), not yet registeredS/N 60959N959FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25133N959NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33329N960AKAlaska Airlines Inc · Seatac, WABuilt 2023 · S/N 44092N960ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29542N960FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 25593N960NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33330N961AKBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 63562N961ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30092N961NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31205N962AKAlaska Airlines Inc · Seattle, WABuilt 2023 · S/N 44078N962ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30858N962BLRegistered aircraftN-number assigned (import), not yet registeredS/N 60962N962NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 33331N963AKAlaska Airlines Inc · Seattle, WABuilt 2023 · S/N 44069N963ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29543N963CAAc Spe 7 LLC · Orlando, FLBuilt 2001 · S/N 32381N963NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31208N964AKAlaska Airlines Inc · Seattle, WABuilt 2023 · S/N 44068N964ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30093N964FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24884N964NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31210N965ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29544N965FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 27622N965NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33239N966AKAlaska Airlines Inc · Seattle, WABuilt 2023 · S/N 67504N966ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30094N966FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 25626N966NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33240N967AKAlaska Airlines Inc · Seatac, WABuilt 2023 · S/N 67419N967ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29545N967NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31214N968AKAlaska Airlines Inc · Seattle, WABuilt 2023 · S/N 67420N968ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30095N968NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33241N969AKAlaska Airlines Inc · Seatac, WABuilt 2023 · S/N 67421N969ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29546N969NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31215N970ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30096N970NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31218N970STNational Nuclear Security Administration · Albuquerque, NMBuilt 2008 · S/N 29645N971AKAlaska Airlines Inc · Seattle, WABuilt 2019 · S/N 43339N971ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29547N971NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31217N972AKAlaska Airlines Inc · Seatac, WABuilt 2021 · S/N 43389N972ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30097
Back to AD 2018-20-13