OpenAirDocs.org
Watertown, SD

Registered aircraft · 66

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'SD' AND g.registrant_city = 'WATERTOWN'
  ORDER BY g.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.

N112FAAir Tractor AT-802A · S/N 802A-1199Built 2025 · Fast Ag Air LLCN123MPRobinson Helicopter R44 II · S/N 12796Built 2010 · Prairie River Farm IncN145XSAeromot AMT-200S · S/N 200145Built 2003 · Lake Area Technical InstituteN16633Six Chuter SR7 XL · S/N 99-2138-SR7XLBuilt 1999 · Hurkes David AN19700Cessna 177B · S/N 17702584Built 1976 · Johnson Dean WN225BABell Textron Canada 505 · S/N 65690Built 2025 · R&R Testing IncN2271NCessna 140 · S/N 12511Built 1947 · Kasuske Gerald AN22FKAir Tractor AT-802 · S/N 802-0965Built 2022 · Fast Ag Air LLCN240MCCanadair CL-600 CHALLENGER · S/N 1075Built 1982 · N240mc LLCN2412MPiper PA-28R-201T · S/N 28R-7803127Built 1977 · Christensen Broadcast Group IncN24947Cessna 152 · S/N 15280464Aty Aviation IncN2543HPowrachute PC 2000 · S/N A63POWBuilt 2000 · Kinney Peter HN29466Piper PA-34-200T · S/N 34-7970257Built 1979 · Lake Area Technical CollegeN30248Powrachute PEGASUS · S/N A 324 PEGBuilt 2004 · Larson Gregory RN313BASchweizer 269D · S/N 0059ABuilt 2006 · R & R Testing IncN333PGPiper PA-28R-201 · S/N 28R-7737114Built 1977 · Aty Aviation IncN333TCTextron T182T · S/N T18209166Built 2025 · Katy Partnership Leasing LLCN34549Beech 58TC · S/N TK-62Octans Aviation CoN3717FCessna 172H · S/N 17255212Built 1966 · Lake Area Technical CollegeN377UHHylio HYL-150 · S/N 17906110219Registration pendingN380KPPiper PA-11 · S/N 11-1586Built 1947 · Peterson Timothy JN3860LCessna 172G · S/N 17254029Built 1965 · Lake Area Technical CollegeN38696Piper PA-28-181 · S/N 28-7790577Built 1977 · Lake Area Technical CollegeN38773Piper PA-28R-201 · S/N 28R-7737117Built 1977 · Gustafson DavidN38FJPiper PA-44-180 · S/N 4495009Built 1989 · Aty Aviation IncN3974LCessna 172G · S/N 17254143Built 1966 · Lake Area Technical CollegeN417QCessna 525 · S/N 525-0385Built 2000 · C P Holdings LLCN4203WAir Tractor AT-802A · S/N 802A-0253Built 2006 · Fast Ag Air LLCN4421PPiper PA-23-160 · S/N 23-1935Built 1960 · Amendt Joseph J JrN4636FPiper PA-28-181 · S/N 28-7790052Built 1976 · Wilkens Wesley JN464LTextron 182T · S/N 18283060Built 2018 · C P Holdings LLCN4674HPiper PA-15 · S/N 15-373Yost Brandon CN4763HPiper PA-11 · S/N 11-666Henricks Alen KN4810HPiper PA-17 · S/N 17-108Kasuske Gerald AN4855HPiper PA-17 · S/N 17-154Built 1948 · Kasuske Gerald AN50490Piper PA-18-150 · S/N 18-5215Built 1956 · Aty Aviation IncN5133ACessna 172 · S/N 28133Built 1955 · Lake Area Technical InstituteN520WTRobbins Jerry L STOL CH 750 · S/N 75-8335Robbins Jerry LN5407RCessna 172F · S/N 17252946Lake Area Technical CollegeN5433ECessna 172N · S/N 17271861Built 1978 · Aty Aviation IncN57201DJI AGRAS T50 · S/N 1581F6BUB245L001Q6X1Lake Area AgN588DCCessna 182S · S/N 18280243Built 1998 · Dynoair LLCN612JCCessna 525A · S/N 525A0366Built 2007 · Katy Partnership Leasing LLCN621TWS C Aerostar S A YAK-52TW · S/N 0312504Built 2003 · Snaza Todd MN6391JCessna 172N · S/N 17273868Built 1980 · Aty Aviation IncN644FLPiper PA-28-140 · S/N 28-7125552Built 1971 · Aty Aviation IncN732YBCessna T210M · S/N 21061871Rieber Gerald MichaelN733FSCessna 172N · S/N 17268266Built 1976 · Arbach Enterprises IncN7370KPiper PA-20 · S/N 20-279Built 1950 · Whitney Aviation LLCN762AFSchweizer SGM2-37 · S/N 10Built 1988 · Lake Area Technical Institute
Back to Watertown, SD