AD 2011-21-08

Registered aircraft · 5,377

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:2011-21-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-21-08')
  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.

N111RZMetropolitan Telecommunications Corp Of De LLC · Holmdel, NJBuilt 2009 · S/N 5792N111USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1114N111ZMAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5983N11206United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30578N112ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 5991N112DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10085N112PSFrontera Flight Holdings Inc · Dover, DEBuilt 1967 · S/N 47013N112USAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1134N112VLBank Of Utah Trustee · Salt Lake City, UTS/N 8011N113ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6020N113DXDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10100N113SRAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1994 · S/N 5164N114DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10122N114UWAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 1148N115DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10132N115NNAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6063N116ANUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6070N116DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10121N116HLWorld Tech Aviation LLC · Valencia, CAS/N 5113N117AACorsair Two LLC · Hillsboro, ORBuilt 1990 · S/N 5060N117ANAmerican Airlines Inc · Fort Worth, TXBuilt 2014 · S/N 6094N117DXDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10133N117UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1224N118DYDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10140N118MTOne World Aviation 118 LLC · Atlanta, GAS/N 5077N118NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6162N118USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1264N119DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10182N119FEFederal Express Corp · Memphis, TNBuilt 2019 · S/N 64057N119NAUnited States Government · Washington, DCBuilt 1989 · S/N 24487N119NNUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6222N119USBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1268N1200KDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28457N1201PDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28458N12028American Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6456N120DNDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10185N120EEUmb Bank Na Trustee · Salt Lake City, UTBuilt 2014 · S/N 6227N120UAUnited Airlines Inc · Chicago, ILBuilt 1999 · S/N 29166N120UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0805N12109United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27299N12114United Airlines Inc · Chicago, ILBuilt 1995 · S/N 27556N12116United Airlines Inc · Chicago, ILBuilt 1996 · S/N 27558N12125United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28967N1217AAndromeda Leasing I LLC · Purchase, NYBuilt 1992 · S/N 25865N121ANBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 6238N121DZDelta Air Lines Inc · Atlanta, GABuilt 2021 · S/N 10233N121UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 0806N121UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 1294N12216United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28776N12218United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28778
Back to AD 2011-21-08