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.

N8822QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67479N8823QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67478N8824QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67477N8825QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67472N8826QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67473N8827QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 42598N8828LSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67474N8829QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67487N882DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31994N882NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 33221N8830QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67750N8831LSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67482N8832HSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67751N8833LSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67481N8834LSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67752N8835QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67486N8836QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67483N8837QSouthwest Airlines Inc · Dallas, TXBuilt 2023 · S/N 67485N8838QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67484N8839QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67489N883DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31993N883NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31137N8840QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67493N8841LSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67492N8842LSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67793N8843SSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67491N8844QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67488N8845LSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67794N8846QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67490N8847QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 42600N8848QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67795N8849QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67826N884DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31995N884NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33222N8850QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67498N8851QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67825N8852QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67497N8853QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67496N8854QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67494N8855QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67495N8856SSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67470N8857QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67471N8858KSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 42591N8859QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 42657N885DNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2017 · S/N 31996N885NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31139N8860SSouthwest Airlines Co · Dallas, TXS/N 42671N8861QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67865N8862QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67863N8863QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67864
Back to AD 2018-20-13