AD 2002-22-12

Registered aircraft · 2,065

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

N248FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67545N249BABoeing Aircraft Holding Co · Seattle, WAS/N 24309N249FEFederal Express Corporation · Memphis, TNBuilt 2025 · S/N 67544N24KTFalcon Type Air LLC · Nashville, TNBuilt 1995 · S/N 650-7052N250FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67543N250UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48745N251AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1999 · S/N 29604N251FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67542N251UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 48744N25201United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28958N252FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67541N252UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 48768N253FEFederal Express Corp · Memphis, TNBuilt 2025 · S/N 67540N254FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67539N254UPUnited Parcel Service Co · Louisville, KYBuilt 1993 · S/N 48406N255CMCargo Aircraft Management Inc · Wilmington, OHBuilt 1984 · S/N 22316N255FEFederal Express Corporation · Memphis, TNBuilt 2024 · S/N 67538N255UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48404N256FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67537N256UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48405N257AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1999 · S/N 29605N257FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67536N257UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48451N258FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67535N258SNB29258 LLC · Estero, FLBuilt 1999 · S/N 29258N258UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 48416N259FEFederal Express Corp · Memphis, TNBuilt 2024 · S/N 67534N25EGGarcia Airways LLC · Virginia Beach, VABuilt 1989 · S/N 650-0167N25VRr Aero LLC · Carson City, NVS/N 1015N260FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67533N260UPUnited Parcel Service Co · Louisville, KYBuilt 1992 · S/N 48418N261FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67532N261UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48805N26208United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30580N26210United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28770N26215United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28775N26226United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28935N26232United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28942N262FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67531N262UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48806N263FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 67530N263SGAtlas Air Inc · Purchase, NYBuilt 1999 · S/N 29263N263UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 48782N264FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66869N264GVCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 650-0104N264UPUnited Parcel Service Co · Louisville, KYBuilt 2000 · S/N 48800N265FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66868N265UPUnited Parcel Service Co · Louisville, KYBuilt 2001 · S/N 48803N266FEFederal Express Corp · Memphis, TNBuilt 2022 · S/N 66867N267FEFederal Express Corp · Memphis, TNBuilt 2023 · S/N 66866
Back to AD 2002-22-12