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.

N909DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64880N909NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31159N910ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29512N910DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32011N910FDFederal Express Corp · Memphis, TNBuilt 1991 · S/N 25054N910NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2012 · S/N 31160N910UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67980N911DQDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64882N912AKAlaska Airlines Inc · Seattle, WABuilt 2023 · S/N 67507N912ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29513N912DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64883N912NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 33319N912UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67981N913AKAlaska Airlines Inc · Seattle, WABuilt 2021 · S/N 44079N913ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29514N913DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62781N913NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29571N913UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67982N914ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29515N914DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 62782N914NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 31161N914UPUnited Parcel Service Co · Louisville, KYBuilt 2025 · S/N 67983N915AKAlaska Airlines Inc · Seattle, WABuilt 2021 · S/N 44080N915ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29516N915DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 62783N915FDFederal Express Corp · Memphis, TNBuilt 1988 · S/N 24120N915NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33227N915UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 67984N916ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29517N916DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 64884N916NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31163N916UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 67985N917AKAlaska Airlines Inc · Seatac, WABuilt 2023 · S/N 67500N917ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29518N917DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 63530N917NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 29572N917UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68363N918AKAlaska Airlines Inc · Seatac, WABuilt 2021 · S/N 44083N918ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29519N918DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 64885N918NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2013 · S/N 33228N918UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68364N919AKAlaska Airlines Inc · Seattle, WABuilt 2021 · S/N 44087N919ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29520N919DUDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 63531N919NNBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2013 · S/N 29573N919RATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 30174N919UPUnited Parcel Service Co · Louisville, KYBuilt 2026 · S/N 68365N920AKAlaska Airlines Inc · Seatac, WABuilt 2021 · S/N 44086N920ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29521
Back to AD 2018-20-13