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.

N8945QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68632N8946LUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 42599N8947QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68631N8948QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68630N8949QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68629N894DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62776N894NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31147N8950LSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42596N8951SSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42612N8952QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68891N8953QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68890N8954QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42606N8955QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42617N8956QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68894N8957QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68892N8958QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68893N8959QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68927N895DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32003N895NNWilmingtontrust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31149N8960LSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42608N8961KSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42619N8962LSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68925N8963QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42622N8964LSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68926N8965QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42610N8966SSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42626N8967QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68932N8969SSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68928N896DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62777N896NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 33224N8970QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68929N8971LSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 68931N8972SSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 36981N8973SSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42630N8974KSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 67325N8975KSouthwest Airlines Co · Dallas, TXS/N 67326N8976KSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42668N8977GSouthwest Airlines Co · Dallas, TXS/N 42675N8978GSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 69677N8979LSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 69678N897AKAlaska Airlines Inc · Seattle, WABuilt 2025 · S/N 67508N897DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32004N897NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 33318N8980QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 36986N8981QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 36982N8982SSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42677N8983QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 67468N8984LSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42692N8985QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 42676N8986QSouthwest Airlines Co · Dallas, TXBuilt 2025 · S/N 69915
Back to AD 2018-20-13