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.

N877NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31131N8780QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67753N8781QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67758N8782QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67759N8783LSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67754N8784QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67757N8785LSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67755N8786QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67782N8787KSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67778N8788LSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67777N8789QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67776N878DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31989N878NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40768N8790QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67773N8791DSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67779N8792QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67774N8793QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67781N8794QSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67784N8795LSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67785N8796LSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67783N8797QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67787N8798QSouthwest Airlines Co · Dallas, TXBuilt 2023 · S/N 67786N879DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31990N879NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31133N8800LSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 42633N8801QSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 65436N8802QSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 65437N8803LSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 42634N8804LSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 42637N8805LSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 42641N8806QSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 65471N8807LSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 65438N8808QSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 65440N8809LSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 65439N880DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31991N880NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 40769N8810LSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 42647N8811LSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 42661N8812QSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 42662N8813QSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 42646N8814KSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 42664N8815LSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 65473N8816QSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 42536N8817LSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 42537N8818QSouthwest Airlines Co · Dallas, TXBuilt 2021 · S/N 36722N8819LSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67476N881DNDelta Air Lines Inc · Atlanta, GABuilt 2017 · S/N 31992N881NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 31135N8820LSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67475N8821SSouthwest Airlines Co · Dallas, TXBuilt 2022 · S/N 67480
Back to AD 2018-20-13