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.

N192FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63123N192UWBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 1496N193ANWilmington Trust Company Trustee · Wilmington, DEBuilt 2001 · S/N 32387N193DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28450N193FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63124N193JCWt 1 Interests LLC · Houston, TXBuilt 1991 · S/N 650-0199N194DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28451N194UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26892N195DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28452N195FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63125N195UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26899N196AAWyatt Aerospace LLC · Chandler, AZBuilt 2001 · S/N 32390N196DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28453N196FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63126N197DNDelta Air Lines Inc · Atlanta, GABuilt 1997 · S/N 28454N197FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63127N197UAUnited Airlines Inc · Chicago, ILBuilt 1997 · S/N 26901N198DNDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28455N198FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63128N1997AAndromeda Leasing II LLC · Purchase, NYBuilt 1994 · S/N 27310N199ANAersale Inc · Doral, FLBuilt 2001 · S/N 32393N199DNDelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 28456N199FEFederal Express Corp · Memphis, TNBuilt 2021 · S/N 63129N19QCOn Three Angels Wings LLC · Melbourne, FLBuilt 1994 · S/N 650-0238N200LHEagle Nation Aviation LLC · Macon, GABuilt 1992 · S/N 650-7005N200WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32482N201LVSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 29854N202AVAvista Corp · Spokane, WABuilt 1999 · S/N 650-7108N202JKRosado Aviation Inc · Moosic, PABuilt 1985 · S/N 650-0100N202JPAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1994 · S/N 650-7046N203WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32483N204BBCentex Aero LLC Trustee · San Antonio, TXBuilt 1990 · S/N 650-0189N204WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 29855N205WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34010N206WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34011N207AXOmni Planes LLC · Tulsa, OKBuilt 2001 · S/N 30438N207WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34012N208WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 29856N209TRCareer Aviation Co Inc · Wilmington, DEBuilt 1976 · S/N 20994N209WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32484N2105Premier Jets Inc · Hillsboro, ORS/N 1010N210WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34162N21108United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27298N211WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34163N212WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32485N213USMuseum Of Flight Foundation · Seattle, WABuilt 1969 · S/N 20213N213WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34217N214WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32486N215WNSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32487N216WRSouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 32488
Back to AD 2002-22-12