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.

N315UAAmerican Airlines Inc · Fort Worth, TXBuilt 2024 · S/N 44508N315UUAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 68362N315VCAmerican Airlines Inc · Fort Worth, TXBuilt 2026 · S/N 69214N3160GUmb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 32277N316PFAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31262N316RKWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 44450N316SEWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 44472N316UVAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 68108N316VDAmerican Airlines Inc · Fort Worth, TXBuilt 2026 · S/N 69423N317AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1992 · S/N 25445N317CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24317N317PGAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 33344N317UWAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 68456N317VEAmerican Airlines Inc · Fort Worth, TXBuilt 2026 · S/N 69520N318FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2000 · S/N 28318N318SFWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 44473N318TDAmerican Airlines Inc · Fort Worth, TXBuilt 2023 · S/N 68114N318UXAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 68109N319CMCargo Aircraft Management Inc · Wilmington, OHS/N 24407N319TEAmerican Airlines Inc · Fort Worth, TXBuilt 2023 · S/N 68099N319UYAmerican Airlines Inc · Fort Worth, TXBuilt 2025 · S/N 68110N319VFAmerican Airlines Inc · Fort Worth, TXBuilt 2026 · S/N 44534N320TFAmerican Airlines Inc · Fort Worth, TXBuilt 2023 · S/N 68100N320VGAmerican Airlines Inc · Fort Worth, TXBuilt 2026 · S/N 44527N321CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1998 · S/N 29431N321RLWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 44452N321TGAmerican Airlines Inc · Fort Worth, TXBuilt 2023 · S/N 68101N321VHAmerican Airlines Inc · Fort Worth, TXBuilt 2026 · S/N 44526N322THAmerican Airlines Inc · Fort Worth, TXBuilt 2023 · S/N 68102N322VJAmerican Airlines Inc · Fort Worth, TXBuilt 2026 · S/N 44528N323CMBank Of Utah Trustee · Salt Lake City, UTS/N 29881N323RMWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 44453N323SGWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 44474N323VKAmerican Airlines Inc · Fort Worth, TXBuilt 2026 · S/N 44530N32404United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30121N324RAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 44459N324RNWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 44454N324SHWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 44476N324VLAmerican Airlines Inc · Fort Worth, TXBuilt 2026 · S/N 44529N325FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 28325N325VMAmerican Airlines Inc · Fort Worth, TXBuilt 2026 · S/N 44531N326FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 28326N326RPWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 44456N326SJWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 44475N326VNAmerican Airlines Inc · Fort Worth, TXBuilt 2026 · S/N 44532N327SKWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 44477N327VPAmerican Airlines Inc · Fort Worth, TXBuilt 2026 · S/N 44533N328RRWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N 44457N328TCAmerican Airlines Inc · Fort Worth, TXBuilt 2023 · S/N 68115N329SLWilmington Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 44479
Back to AD 2018-20-13