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.

N902NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31154N9030SSouthwest Airlines Co · Dallas, TXBuilt 2026 · S/N 70633N9031WSouthwest Airlines Co · Dallas, TXBuilt 2026 · S/N 69014N9032RSouthwest Airlines Co · Dallas, TXBuilt 2026 · S/N 69015N9033WSouthwest Airlines Corp · Dallas, TXBuilt 2026 · S/N 67334N9034RSouthwest Airlines Co · Dallas, TXBuilt 2026 · S/N 70632N9035WSouthwest Airlines Co · Dallas, TXS/N 70634N9036WSouthwest Airlines Co · Dallas, TXS/N 69013N9037SSouthwest Airlines Co · Dallas, TXS/N 67338N9038WSouthwest Airlines Co · Dallas, TXS/N 67337N9039SBoeing Co · Renton, WAS/N 70688N903AKAlaska Airlines Inc · Seatac, WABuilt 2023 · S/N 67425N903ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29505N903DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32007N903NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31153N9040WSouthwest Airlines Co · Dallas, TXS/N 70689N9041JSouthwest Airlines Co · Dallas, TXS/N 70690N9042RSouthwest Airlines Co · Dallas, TXS/N 67336N9043DSouthwest Airlines Co · Dallas, TXS/N 42639N9044HSouthwest Airlines Co · Dallas, TXS/N 42636N9045HBoeing Co · Renton, WAS/N 69036N9046HBoeing Co · Renton, WAS/N 69041N9047RBoeing Co · Renton, WAS/N 70630N9048RBoeing Co · Renton, WAS/N 70698N9049RBoeing Co · Renton, WAS/N 69044N904ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29506N904DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32008N904NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33317N9050RBoeing Co · Renton, WAS/N 67340N9051RBoeing Co · Renton, WAS/N 67405N9052SBoeing Co · Renton, WAS/N 69043N9053WBoeing Co · Renton, WAS/N 70687N9054RBoeing Co · Renton, WAS/N 42640N9055RBoeing Co · Renton, WAS/N 67342N9056WBoeing Co · Renton, WAS/N 70699N9057EBoeing Co · Renton, WAS/N 42628N9058HBoeing Co · Renton, WAS/N 70812N905ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29507N905DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32009N905NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31156N906ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29508N906DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 64879N906NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31155N907ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29509N907DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32010N907NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31158N908ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29510N908DNDelta Air Lines Inc · Atlanta, GAS/N 64881N908NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31157N909ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29511
Back to AD 2018-20-13