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.

N945NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 33233N946AKAlaska Airlines Inc · Seattle, WABuilt 2022 · S/N 44085N946ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30600N946FDFederal Express Corp · Memphis, TNS/N 24398N946NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 33234N947AKAlaska Airlines Inc · Seattle, WABuilt 2023 · S/N 67506N947ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29536N947FDFederal Express Corp · Memphis, TNS/N 24882N947NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31190N948AKAlaska Airlines Inc · Seattle, WABuilt 2022 · S/N 44090N948ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30086N948FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25059N948NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31189N949AKBank Of Utah Trustee · Salt Lake City, UTS/N 43356N949ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29537N949FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25060N949NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 31192N950AMUmb Bank Na Owner Trustee · Salt Lake City, UTS/N 35115N950ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30087N950FDFederal Express Corp · Memphis, TNBuilt 1994 · S/N 25806N950NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31194N951AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29538N951FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28665N951NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 33327N952AAAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30088N952AKBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 60390N952FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28666N952NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31196N953AKAlaska Airlines Inc · Seattle, WABuilt 2022 · S/N 44103N953ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29539N953FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 28667N953NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 33328N954AKAlaska Airlines Inc · Seattle, WABuilt 2022 · S/N 44104N954ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30089N954FDFederal Express Corp · Memphis, TNBuilt 1997 · S/N 29113N954NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31197N955AKBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 63810N955ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29540N955FDFederal Express Corp · Memphis, TNBuilt 1998 · S/N 29114N955NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31199N956AKBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 43360N956ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30090N956FDFederal Express Corp · Memphis, TNBuilt 1998 · S/N 29115N956NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 31200N957AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 39957N957ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29541N957NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2014 · S/N 31202N958AKAlaska Airlines Inc · Seatac, WABuilt 2023 · S/N 44072N958AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2015 · S/N 39958N958ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30091
Back to AD 2018-20-13