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.

N471USU S Department Of Homeland Security · Arlington, VABuilt 2018 · S/N 61329N47275United Airlines Inc · Chicago, ILBuilt 2022 · S/N 64610N47280United Airlines Inc · Chicago, ILBuilt 2022 · S/N 64614N47281United Airlines Inc · Chicago, ILBuilt 2022 · S/N 62535N47282United Airlines Inc · Chicago, ILBuilt 2022 · S/N 61861N47284United Airlines Inc · Chicago, ILBuilt 2022 · S/N 61863N47288United Airlines Inc · Chicago, ILBuilt 2022 · S/N 61856N47291United Airlines Inc · Chicago, ILBuilt 2023 · S/N 62182N47293Umb Bank Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 67552N47298United Airlines Inc · Chicago, ILBuilt 2024 · S/N 67611N472ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 60580N472TNUmb Bank Na Trustee · Salt Lake City, UTS/N 29863N47330United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67588N47332Umb Bank Na Trustee · Salt Lake City, UTBuilt 2024 · S/N 67586N47340Umb Bank Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 67600N47343Umb Bank Na Trustee · Salt Lake City, UTBuilt 2024 · S/N 67607N47345United Airlines Inc · Chicago, ILBuilt 2024 · S/N 67619N47357United Airlines Inc · Chicago, ILBuilt 2025 · S/N 67633N47360United Airlines Inc · Chicago, ILBuilt 2025 · S/N 68827N47369United Airlines Inc · Chicago, ILBuilt 2025 · S/N 68822N47370United Airlines Inc · Chicago, ILBuilt 2025 · S/N 68823N47412Wilmington Trust Co Trustee · Wilmington, DEBuilt 2025 · S/N 68811N47414United Airlines Inc · Chicago, ILBuilt 2008 · S/N 32827N47434Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67663N47446United Airlines Inc · Chicago, ILBuilt 2026 · S/N 43527N47453Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 62676N47457Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 67648N47462United Airlines Inc · Chicago, ILBuilt 2026 · S/N 67656N47470Wilmington Trust Co Owner Trustee · Wilmington, DEBuilt 2026 · S/N 67661N474ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 40715N47505United Airlines Inc · Chicago, ILBuilt 2018 · S/N 43433N47512United Airlines Inc · Chicago, ILBuilt 2019 · S/N 43449N47517Wilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 43456N47524Wilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 64501N47533United Airlines Inc · Chicago, ILBuilt 2022 · S/N 66120N47569United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67189N47570United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67194N475USUS Department Of Homeland Security · Arlington, VABuilt 2004 · S/N 33789N477ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 40716N477USUS Department Of Homeland Security · Arlington, VABuilt 2003 · S/N 33785N478ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 44105N479AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 68121N479ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 60576N479AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1993 · S/N 25450N48127United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28968N481ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 44106N481CMCargo Aircraft Management Inc · Wilmington, OHS/N 26992N483ASAlaska Airlines Inc · Seattle, WABuilt 2015 · S/N 36350N486ASAlaska Airlines Inc · Seatac, WABuilt 2015 · S/N 44107N487ASAlaska Airlines Inc · Seatac, WABuilt 2015 · S/N 44108
Back to AD 2018-20-13