AD 2002-19-10

Registered aircraft · 1,092

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-19-10')
    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-19-10')
  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.

N324BSB&S Air Inc · Lumpkin, GABuilt 2025 · S/N 802A-1189N325BGTurrell Flying Service Inc · Turrell, ARBuilt 2010 · S/N 602-1188N325BMFarm Air Service Inc · Tallulah, LABuilt 2003 · S/N 802A-0144N329LAWells Flying Services LLC · Holdrege, NES/N 802A-0345N332ATAg Solutions LLC · Satanta, KSBuilt 1999 · S/N 802A-0087N332BSHog Air Aviation Inc · Paragould, ARBuilt 2019 · S/N 802A-0791N333BRB&R Aerial Crop Care Inc · Connell, WABuilt 2022 · S/N 802A-0989N334BSMitchell Andrew D Trustee · Winnie, TXS/N 802A-0521N335BSOld River Flying Service LLC · Helena, ARBuilt 2016 · S/N 802A-0643N335LAAir Tractor Inc · Olney, TXS/N 802-1335N335QFBearcreek Flying Service LLC · Oakes, NDBuilt 2013 · S/N 802A-0522N339BSB & S Air Inc · Lumpkin, GABuilt 2020 · S/N 802A-0839N340LATri-Air Farms LLC · Mamou, LABuilt 2009 · S/N 802A-0349N344VAAir Tractor Inc · Olney, TXS/N 802A-1344N347BMAir Tractor Inc · Olney, TXS/N 802A-1347N347ERO'Briens Flying Service Inc · Iowa, LABuilt 2022 · S/N 802A-0944N347REAir Tractor Inc · Olney, TXS/N 802A-1331N349ASAero Applicators Inc · Sterling, COBuilt 2015 · S/N 802A-0603N350DAAir Tractor Inc · Olney, TXS/N 802A-1354N354FSAnderson Interests LLC · East Bernard, TXBuilt 2010 · S/N 802A-0355N358ASNew Frontier Aviation LLC · Fort Benton, MTBuilt 2015 · S/N 802A-0604N363ATAeronautical Technologies Inc · Clovis, NMBuilt 2013 · S/N 802A-0508N363GSParrish Aerial Services LLC · Wilmington, DEBuilt 2015 · S/N 802-0587N365LAFarm 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-0399N373FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2024 · S/N 602-1373N376ASAero 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-0389N392FBFarm Brothers Flyers A LLC · Gould, ARBuilt 2025 · S/N 602-1392N392KWSpradin Flying Service Inc · Petersburg, TXBuilt 2007 · S/N 802A-0282N392LAC&L Holzwarth Inc · Virden, ILBuilt 2025 · S/N 602-1391N392TMCentral Farmer'S Cooperative DBA · Ville Platte, LABuilt 2009 · S/N 602-1179N393LAC&L Holzwarth Inc · Virden, ILBuilt 2024 · S/N 802A-1093N394TMWebb Flying Service Inc · Coy, ARBuilt 2016 · S/N 602-1279N396LANeal 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-0263N398RKAir Worthy Inc · Lyon, MSBuilt 1998 · S/N 602-0484N4012JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2012 · S/N 602-1213N4025MSky Tech Inc · Dorchester, NES/N 602-1399N402CSWoodley 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-1125
Back to AD 2002-19-10