AD 2002-11-05

Registered aircraft · 948

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-11-05')
    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-11-05')
  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.

N3659NHoppe Air LLC · Beaman, IAS/N 400-0294N365LAFarm Air Corp · Minturn, ARBuilt 2010 · S/N 802A-0365N369ZPRegistration Pending · Pasco, WARegistration pendingBuilt 2025 · S/N 802A-1253N370JBAurora Cooperative Elevator Co · Aurora, NEBuilt 2011 · S/N 802A-0399N376ASAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0607N379ASAero Spray Inc DBA · Appleton, MNBuilt 2015 · S/N 802A-0609N385LABrunetti Finley Jr · Shelby, MSBuilt 2010 · S/N 802A-0385N386LAHinkle Airspray Inc · Cavalier, NDBuilt 2010 · S/N 802A-0386N389LABailey Air LLC · Delhi, LABuilt 2010 · S/N 802A-0389N392KWSpradin Flying Service Inc · Petersburg, TXBuilt 2007 · S/N 802A-0282N393LAC&L Holzwarth Inc · Virden, ILBuilt 2024 · S/N 802A-1093N396LANeal Aircraft Inc · Slaton, TXS/N 802A-0331N397LAWil-Co Flying Service LLC · Dewitt, ARBuilt 2009 · S/N 802A-0332N398ASAero Spray Inc DBA · Appleton, MNBuilt 2014 · S/N 802A-0564N398LAWestern Pilot Service Inc · League City, TXBuilt 2007 · S/N 802A-0263N39GJTri County Ag Service Inc · Ipswich, SDBuilt 1997 · S/N 401B-1023N400XXAbernathy Spraying Service Inc · Tipton, OKBuilt 1986 · S/N 4000646N401BMBart'S Flying Service Inc · Storm Lake, IABuilt 1992 · S/N 401-0853N401CWDakotawild Aviation Inc · Westhope, NDBuilt 1992 · S/N 401-0870N401KREast Air Aviation LLC · Cullman, ALBuilt 1991 · S/N 401-0813N401NEBender Jace Edwin Fredrick · Humphrey, NEBuilt 1994 · S/N 401B0960N401THAerial Ag Services LLC · Hillsboro, TXS/N 401-0875N402CSWoodley Aerial Leasing LLC · Walnut, ILBuilt 1991 · S/N 402A-0816N402CWThisius Flying Service Llp · Wells, MNBuilt 1998 · S/N 402A-1061N402DEDeby Ag Leasing Lp · Wakarusa, INBuilt 1991 · S/N 402-0807N402DGNorth Central Aviation LLC · Valentine, NEBuilt 1999 · S/N 402A-1091N402FAgriculture Aviation Services LLC · Clarkfield, MNS/N 402A-1125N402FHAasjng LLC · Holdrege, NES/N 402B-1254N402GKGress Air LLC · Dunbar, NEBuilt 2004 · S/N 402A-1151N402JDefenbaugh Matthew J · Biggsville, ILBuilt 2000 · S/N 402A-1117N402JGWhalen Mark P · Millington, MDBuilt 2013 · S/N 402B-1277N402JWKeahey Aviation LLC · West Monroe, LAS/N 402B-1249N402KKKevin Kingsley LLC · Lamar, MOBuilt 2020 · S/N 402B-1430N402LTBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 402B-1163N402PRBarts Flying Service Inc · Storm Lake, IABuilt 2013 · S/N 402B-1282N402REKingrey William S III · Richmond, TXBuilt 1997 · S/N 402A-1027N402SKOli Grow LLC · Baskin, LAS/N 402-0895N402SROli Grow LLC · Baskin, LABuilt 1994 · S/N 402-0939N402TSunflower Aero Inc · Atwood, KSBuilt 1998 · S/N 402A-1060N402TMShores Ag-Air Inc · Robstown, TXBuilt 2005 · S/N 402B-1164N402TTSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 402B-1304N402UWestern Ag Aviation Inc · Plains, KSBuilt 1999 · S/N 402A-1116N402VA + Aviation Services LLC · Goodland, KSBuilt 1998 · S/N 402A-1050N402WD402wd Holdings LLC · Corpus Christi, TXBuilt 1999 · S/N 402A-1090N402WRHoxie Sprayers Inc · Hoxie, KSBuilt 2011 · S/N 402B-1244N402YSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 402B-1285N402ZSevcik Clint · Medford, MNBuilt 2012 · S/N 402B-1252N4036FSaffer Spray Service Inc · Fowler, COS/N 402A-1058N406BMEvergreen Flying Service Inc · Rayville, LABuilt 2007 · S/N 802-0265N408ACOver & Under Flying Service Inc · Winamac, INBuilt 1993 · S/N 4010921
Back to AD 2002-11-05