OpenAirDocs.org
Watertown, WI

Registered aircraft · 37

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 = 'WI' 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.

N1024QPiper PA-28-181 · S/N 28-7790370Built 1977 · Duroc LLCN168GGCessna 414A · S/N 414A0304Built 1979 · Wisconsin Aviation IncN18071Cessna 150L · S/N 15073773Built 1972 · Rock River AviationN229DMPiper PA-28-181 · S/N 28-7890246Built 1977 · Wisconsin Aviation IncN25148Silvaire LUSCOMBE 8C · S/N 1072Built 1939 · Lisitza Mark RN25783Piper J3F-60 · S/N 3738Built 1939 · Tegtmeier Michael CN2664FCessna 414A · S/N 414A0534Built 1980 · Wisconsin Aviation IncN2885GPiper PA-28-181 · S/N 28-8090001Built 1979 · Wisconsin Aviation IncN3211ZBalloon Works FIREFLY 7-15 · S/N F71029Built 1997 · Sokovich Caleb SN3421ECessna 172N · S/N 17271539Built 1978 · Wisconsin Aviation IncN34EHPiper PA-34-220T · S/N 3448031Built 1993 · Wisconsin Aviation IncN3738EAeronca 7AC · S/N 7AC-7115Built 1947 · Wright Peter SN3859RCessna 172H · S/N 17255359Built 1966 · Leja Dennis AN441BWCessna 441 · S/N 441-0034Wisconsin Aviation IncN473SMDJI T50 · S/N 63YBMAA0002002URegistration pendingN49288Cessna 152 · S/N 15281226Built 1977 · Wisconsin Aviation IncN49551Cessna 152 · S/N 15283474Built 1979 · Wahl Dale HN52525Allen Mulderink/Todd Ripp HATZ · S/N 197Built 2023 · Mulderink Allen FN626JPDJI AGRAS T40 · S/N 64TBL1X002001UPernat JohnN65561Cessna 152 · S/N 15281619Built 1978 · Wisconsin Aviation IncN6566FCessna 150F · S/N 15063166Built 1966 · Odekirk David CN67314Cessna 152 · S/N 15281746Built 1978 · Wisconsin Aviation IncN6878CPiper PA-34-200T · S/N 34-7870166Built 1978 · Wisconsin Aviation IncN701SREffinger R/Effinger S ZENAIR CH701 · S/N 7-1436Built 1992 · Effinger Randall JN708ESCirrus Design SR22 · S/N 1856Built 2006 · Wisconsin Aviation IncN7151RPiper PA-28-140 · S/N 28-21858Birnschein Daniel JN757JPTalos Drones T60X · S/N 2104F7EZW25670015JCGCreek Bend Farms LLCN8076HPiper PA-34-200T · S/N 34-7970484Built 1979 · Wisconsin Aviation IncN80968Piper PA-28-161 · S/N 28-8016087Built 1979 · Wisconsin Aviation IncN811LCessna 172 · S/N 29014Built 1956 · Tegtmeier Michael CN831JFFricano Joseph P FRICANO ZODIAC-601 · S/N 31097J.P.F-1Duris Wayne PN8323APiper PA-28-161 · S/N 28-8216019Built 1981 · Wisconsin Aviation IncN8410NBeech E33 · S/N CD-1169Built 1968 · Wahl Dale HN8426GPiper PA-34-220T · S/N 34-8133195Built 1981 · Wisconsin Aviation IncN9002ECessna 172N · S/N 17272214Built 1979 · Wisconsin Aviation IncN9143UCessna 150M · S/N 15078094Built 1976 · Sherer Preston AN94429Cessna 152 · S/N 15285669Built 1982 · Wisconsin Aviation Inc
Back to Watertown, WI