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.

N769AMUmb Bank Na Trustee · Salt Lake City, UTBuilt 2023 · S/N 66361N77066United Airlines Inc · Chicago, ILBuilt 2002 · S/N 29461N770BBYucaipa Companies LLC · Burbank, CABuilt 1991 · S/N 25220N770FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24743N771FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24799N77258United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30802N77259Wilmington Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 43462N77261United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31582N77295United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34001N77296United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34002N772FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24840N773AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22788N773FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 24872N77426Umb Bank Na Trustee · Salt Lake City, UTBuilt 2026 · S/N 66117N77430United Airlines Inc · Chicago, ILBuilt 2009 · S/N 37098N77431United Airlines Inc · Chicago, ILBuilt 2009 · S/N 32833N77471Wilmington Trust Co Trustee · Wilmington, DEBuilt 2026 · S/N 67667N774AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1983 · S/N 22789N774FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 26709N77510United Airlines Inc · Chicago, ILBuilt 2008 · S/N 32828N77518United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31605N77520United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31658N77525United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31659N77530United Airlines Inc · Chicago, ILBuilt 2011 · S/N 39998N77535United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62751N77536United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62766N77537United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62767N77538United Airlines Inc · Chicago, ILBuilt 2016 · S/N 63694N77539United Airlines Inc · Chicago, ILBuilt 2017 · S/N 63642N77542United Airlines Inc · Chicago, ILBuilt 2017 · S/N 63647N77543United Airlines Inc · Chicago, ILBuilt 2022 · S/N 64474N77544United Airlines Inc · Chicago, ILBuilt 2022 · S/N 64473N77552United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67179N77558United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67585N77559United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67183N77571United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67193N77572United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67192N77573United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67603N77575United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67609N77576United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67610N77578United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67613N77579United Airlines Inc · Chicago, ILBuilt 2023 · S/N 67614N77580United Airlines Inc · Chicago, ILBuilt 2024 · S/N 67738N77581Bank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 43522N77582Umb Bank Na Trustee · Salt Lake City, UTBuilt 2024 · S/N 43521N77584Umb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 67624N77585Bank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 68826N77587Bank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 67631N77588Umb Bank Na Trustee · Salt Lake City, UTBuilt 2024 · S/N 43446N77590Bank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 67635
Back to AD 2018-20-13