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.

N8705QSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 42558N8706WSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 42559N8707PSouthwest Airlines Co · Dallas, TXS/N 36929N8708QSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 42566N8709QSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 42563N870DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31981N870NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40765N8710MSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 42567N8711QSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 36979N8712LSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 36930N8713MSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 36984N8714QSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 36934N8715QSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 42570N8716BSouthwest Airlines Co · Dallas, TXBuilt 2017 · S/N 42544N8717MSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 42571N8718QSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 42546N8719QSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 42572N871DNUmb Bank Na Trustee · Salt Lake City, UTS/N 31982N871HKSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67775N871NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 31127N8720LSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 42547N8721JSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 42548N8722LUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 37019N8723QUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 42574N8724JUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 42549N8725LUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 42575N8726HSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 42573N8727MSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 42576N8728QUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 42577N8729HUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 37043N872CBSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67780N872DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31983N872NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 33219N8730QUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 37042N8731JUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 42550N8732SUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 42551N8733MBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 60710N8734QBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 60713N8735LBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 60711N8736JWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 60228N8737LWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 60230N8738KWilmington Trust Company Trustee · Wilmington, DEBuilt 2020 · S/N 60229N8739LWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 60231N873DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31984N873NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40766N8740AUmb Bank Na Trustee · Salt Lake City, UTBuilt 2021 · S/N 61860N8741LUmb Bank Na Trustee · Salt Lake City, UTBuilt 2021 · S/N 61869N8742MUmb Bank Na Trustee · Salt Lake City, UTBuilt 2020 · S/N 61868N8743KUmb Bank Na Trustee · Salt Lake City, UTBuilt 2021 · S/N 62536N87442Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67671
Back to AD 2018-20-13