# Registered aircraft: Watertown, WI

A list on [Watertown, WI](https://openairdocs.org/faa-place/WI/Watertown.md).

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

- [N1024Q](https://openairdocs.org/aircraft/N1024Q.md): Piper PA-28-181 · S/N 28-7790370 · Built 1977 · Duroc LLC
- [N168GG](https://openairdocs.org/aircraft/N168GG.md): Cessna 414A · S/N 414A0304 · Built 1979 · Wisconsin Aviation Inc
- [N18071](https://openairdocs.org/aircraft/N18071.md): Cessna 150L · S/N 15073773 · Built 1972 · Rock River Aviation
- [N229DM](https://openairdocs.org/aircraft/N229DM.md): Piper PA-28-181 · S/N 28-7890246 · Built 1977 · Wisconsin Aviation Inc
- [N25148](https://openairdocs.org/aircraft/N25148.md): Silvaire LUSCOMBE 8C · S/N 1072 · Built 1939 · Lisitza Mark R
- [N25783](https://openairdocs.org/aircraft/N25783.md): Piper J3F-60 · S/N 3738 · Built 1939 · Tegtmeier Michael C
- [N2664F](https://openairdocs.org/aircraft/N2664F.md): Cessna 414A · S/N 414A0534 · Built 1980 · Wisconsin Aviation Inc
- [N2885G](https://openairdocs.org/aircraft/N2885G.md): Piper PA-28-181 · S/N 28-8090001 · Built 1979 · Wisconsin Aviation Inc
- [N3211Z](https://openairdocs.org/aircraft/N3211Z.md): Balloon Works FIREFLY 7-15 · S/N F71029 · Built 1997 · Sokovich Caleb S
- [N3421E](https://openairdocs.org/aircraft/N3421E.md): Cessna 172N · S/N 17271539 · Built 1978 · Wisconsin Aviation Inc
- [N34EH](https://openairdocs.org/aircraft/N34EH.md): Piper PA-34-220T · S/N 3448031 · Built 1993 · Wisconsin Aviation Inc
- [N3738E](https://openairdocs.org/aircraft/N3738E.md): Aeronca 7AC · S/N 7AC-7115 · Built 1947 · Wright Peter S
- [N3859R](https://openairdocs.org/aircraft/N3859R.md): Cessna 172H · S/N 17255359 · Built 1966 · Leja Dennis A
- [N441BW](https://openairdocs.org/aircraft/N441BW.md): Cessna 441 · S/N 441-0034 · Wisconsin Aviation Inc
- [N473SM](https://openairdocs.org/aircraft/N473SM.md): DJI T50 · S/N 63YBMAA0002002U · Registration pending
- [N49288](https://openairdocs.org/aircraft/N49288.md): Cessna 152 · S/N 15281226 · Built 1977 · Wisconsin Aviation Inc
- [N49551](https://openairdocs.org/aircraft/N49551.md): Cessna 152 · S/N 15283474 · Built 1979 · Wahl Dale H
- [N52525](https://openairdocs.org/aircraft/N52525.md): Allen Mulderink/Todd Ripp HATZ · S/N 197 · Built 2023 · Mulderink Allen F
- [N626JP](https://openairdocs.org/aircraft/N626JP.md): DJI AGRAS T40 · S/N 64TBL1X002001U · Pernat John
- [N65561](https://openairdocs.org/aircraft/N65561.md): Cessna 152 · S/N 15281619 · Built 1978 · Wisconsin Aviation Inc
- [N6566F](https://openairdocs.org/aircraft/N6566F.md): Cessna 150F · S/N 15063166 · Built 1966 · Odekirk David C
- [N67314](https://openairdocs.org/aircraft/N67314.md): Cessna 152 · S/N 15281746 · Built 1978 · Wisconsin Aviation Inc
- [N6878C](https://openairdocs.org/aircraft/N6878C.md): Piper PA-34-200T · S/N 34-7870166 · Built 1978 · Wisconsin Aviation Inc
- [N701SR](https://openairdocs.org/aircraft/N701SR.md): Effinger R/Effinger S ZENAIR CH701 · S/N 7-1436 · Built 1992 · Effinger Randall J
- [N708ES](https://openairdocs.org/aircraft/N708ES.md): Cirrus Design SR22 · S/N 1856 · Built 2006 · Wisconsin Aviation Inc
- [N7151R](https://openairdocs.org/aircraft/N7151R.md): Piper PA-28-140 · S/N 28-21858 · Birnschein Daniel J
- [N757JP](https://openairdocs.org/aircraft/N757JP.md): Talos Drones T60X · S/N 2104F7EZW25670015JCG · Creek Bend Farms LLC
- [N8076H](https://openairdocs.org/aircraft/N8076H.md): Piper PA-34-200T · S/N 34-7970484 · Built 1979 · Wisconsin Aviation Inc
- [N80968](https://openairdocs.org/aircraft/N80968.md): Piper PA-28-161 · S/N 28-8016087 · Built 1979 · Wisconsin Aviation Inc
- [N811L](https://openairdocs.org/aircraft/N811L.md): Cessna 172 · S/N 29014 · Built 1956 · Tegtmeier Michael C
- [N831JF](https://openairdocs.org/aircraft/N831JF.md): Fricano Joseph P FRICANO ZODIAC-601 · S/N 31097J.P.F-1 · Duris Wayne P
- [N8323A](https://openairdocs.org/aircraft/N8323A.md): Piper PA-28-161 · S/N 28-8216019 · Built 1981 · Wisconsin Aviation Inc
- [N8410N](https://openairdocs.org/aircraft/N8410N.md): Beech E33 · S/N CD-1169 · Built 1968 · Wahl Dale H
- [N8426G](https://openairdocs.org/aircraft/N8426G.md): Piper PA-34-220T · S/N 34-8133195 · Built 1981 · Wisconsin Aviation Inc
- [N9002E](https://openairdocs.org/aircraft/N9002E.md): Cessna 172N · S/N 17272214 · Built 1979 · Wisconsin Aviation Inc
- [N9143U](https://openairdocs.org/aircraft/N9143U.md): Cessna 150M · S/N 15078094 · Built 1976 · Sherer Preston A
- [N94429](https://openairdocs.org/aircraft/N94429.md): Cessna 152 · S/N 15285669 · Built 1982 · Wisconsin Aviation Inc

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/faa-place/WI/Watertown/aircraft

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.