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.

N209LAWest Valley Aviation Inc · Five Points, CABuilt 2011 · S/N 802A-0409N211CHRegistered aircraftS/N 802A-1278N212DTThiel Aircare Inc · Chowchilla, CABuilt 2005 · S/N 802A-0212N212FBAero Spray Inc DBA · Appleton, MNBuilt 2010 · S/N 802A-0368N213BHBighorn Flying Co LLC · Wood River, NEBuilt 2013 · S/N 402B-1279N214RLLassco LLC · Middletown, DEBuilt 2021 · S/N 802-0896N224CNRegistered aircraftBuilt 2020 · S/N 802A-0843N2254LPhoenix Equipment Lc · Nickerson, KSFirst renewal noticeBuilt 1985 · S/N 400-0611N226FBLipan Creek Flying Service LLC · Eola, TXBuilt 2024 · S/N 802A-1157N228RGA+ Aviation Services LLC · Garden City, KSBuilt 2009 · S/N 402B-1223N22FKFast Ag Air LLC · Watertown, SDBuilt 2022 · S/N 802-0965N22WHAeronautical Technologies Inc · Clovis, NMBuilt 1997 · S/N 802A0039N2306ABlanke Jason F · Mandeville, LABuilt 1981 · S/N 400-0345N23618Aerinova Aerial LLC · Mattoon, ILBuilt 1981 · S/N 400-0402N23649Abernathy Spraying Service Inc · Tipton, OKBuilt 1981 · S/N 400-0408N23744Van Horne Robert E · Centralia, ILBuilt 1982 · S/N 400A-0429N2393NMid Mo Ag Air LLC · Boonville, MOS/N 400-0441N23WTAeronautical Technologies Inc · Clovis, NMBuilt 2014 · S/N 802-0568N240DLBlue Earth Flying Service LLC · Blue Earth, MNBuilt 2011 · S/N 402B-1240N240LATwin Cities Aviation Inc · Yuba City, CABuilt 2010 · S/N 802A-0375N246LAChambers County · Anahuac, TXBuilt 2018 · S/N 402B-1400N247SEThiel Air Care Inc · Chowchilla, CABuilt 2012 · S/N 802A-0444N257CAHorizon Air LLC · Lumpkin, GABuilt 2025 · S/N 802-1185N265FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2025 · S/N 802A-1265N268FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2026 · S/N 802A-1268N271LAA+ Aviation Services LLC · Goodland, KSBuilt 2012 · S/N 802A-0471N272DAAero Spray Inc DBA · Appleton, MNBuilt 2025 · S/N 802-1258N274ATBoardman Air Service LLC · Henderson, NEBuilt 2012 · S/N 402B-1251N274BMEvergreen Flying Service Inc · Dover, DEBuilt 2026 · S/N 802A-1274N276ATBoardman Air Service LLC · Henderson, NEBuilt 2024 · S/N 802A-1110N278ATBoardman Air Service LLC · Henderson, NEBuilt 2022 · S/N 802A-0953N281DLThisius Flying Service Llp · Wells, MNBuilt 2013 · S/N 402B-1281N281LABoedeker Flying Service East LLC · Childress, TXBuilt 2008 · S/N 402B-1201N288KWFarm Air Inc · Astoria, ILS/N 802A-1288N291DLNorthstar Aero Spray Inc · Clara City, MNBuilt 2008 · S/N 402B-1199N294LARoma Air Corp · Belle Glade, FLBuilt 2000 · S/N 802A-0094N298LAGregs Crop Care Co Inc · Wilbur, WABuilt 2011 · S/N 802A-0398N299JHJohnson Airspray Inc · Argyle, MNBuilt 1990 · S/N 4010726N3011SH & H Flying Co · Finley, TNBuilt 2013 · S/N 402B-1276N3030CWtas LLC · Dyersburg, TNBuilt 2013 · S/N 402B-1283N3030LShannon Agricultural Flying Inc · Clarksdale, MSBuilt 2015 · S/N 802A-0602N3030QFinke Aviation LLC · Charleston, MSBuilt 2013 · S/N 802A-0509N3033HAkbj LLC · Lewes, DEBuilt 2013 · S/N 802A-0507N3038PAgri-Tech Aviation Inc · Indianola, IABuilt 2013 · S/N 402B-1284N3042SAg Aviation Inc · Muleshoe, TXBuilt 2013 · S/N 802A-0520N3054WMoes Crop Dusting Service Inc · Marysville, CABuilt 2013 · S/N 802A-0525N3056QPalmer Flying Service Inc · Manito, ILBuilt 2013 · S/N 802A-0535N305LAShores Ag-Air Inc · Corpus Christi, TXBuilt 2014 · S/N 402B-1305N3063GChristmas Flying Service LLC · Shelby, MSBuilt 2013 · S/N 802A-0529N3063YWeaver Flying Service Inc · Quincy, WABuilt 2013 · S/N 802A-0524
Back to AD 2002-11-05