# Registered aircraft: Franklin, WI

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

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

- [N1187V](https://openairdocs.org/aircraft/N1187V.md): Stinson VULTEE V-77 · S/N 77-142 · Built 1943 · Gores Thomas J
- [N119LS](https://openairdocs.org/aircraft/N119LS.md): Cessna 182T · S/N 18281119 · Built 2002 · Marsair LLC
- [N124EE](https://openairdocs.org/aircraft/N124EE.md): Cessna 172N · S/N 172-68996 · Wisconsin Fox River Flyers Inc
- [N1254H](https://openairdocs.org/aircraft/N1254H.md): Piper PA-28R-201T · S/N 28R-7703018 · Built 1976 · Sherer Scott
- [N142SV](https://openairdocs.org/aircraft/N142SV.md): Moravan N P Ortrokovice Z142 · S/N 0388 · Built 1983 · Esterle Miroslav M
- [N195J](https://openairdocs.org/aircraft/N195J.md): Cessna 195B · S/N 16123 · Built 1954 · Gores Thomas J
- [N21060](https://openairdocs.org/aircraft/N21060.md): Aeronca K · S/N K-335 · Built 1938 · Gores Thomas J
- [N2156X](https://openairdocs.org/aircraft/N2156X.md): Coleman Terry L SKY RANGER · S/N SKR05.01556 · Built 2005 · Freidmark Donald T
- [N2247D](https://openairdocs.org/aircraft/N2247D.md): Piper PA-28-181 · S/N 28-7990168 · Sky Venture Inc
- [N22777](https://openairdocs.org/aircraft/N22777.md): Dehavilland DHC-1 · S/N C1-0105 · Built 1950 · Whyte Eric
- [N22TK](https://openairdocs.org/aircraft/N22TK.md): Piper PA-24-250 · S/N 24-3541 · Built 1963 · Green Theodore G
- [N2368M](https://openairdocs.org/aircraft/N2368M.md): Piper PA-12 · S/N 12-1500 · Built 1946 · Oconnor Sarah A
- [N313LA](https://openairdocs.org/aircraft/N313LA.md): Aeronca 65-LB · S/N LB-10520 · Gores Thomas J
- [N31807](https://openairdocs.org/aircraft/N31807.md): Aeronca 65-CA · S/N C11220 · Gores Thomas J
- [N31895](https://openairdocs.org/aircraft/N31895.md): Aeronca 65-CA · S/N C11671 · Built 1941 · Gores Thomas J
- [N31954](https://openairdocs.org/aircraft/N31954.md): Aeronca 65-CA · S/N CA12321 · Built 1940 · Gores Thomas J
- [N33858](https://openairdocs.org/aircraft/N33858.md): Aeronca 65-CA · S/N CA14001 · Gores Thomas J
- [N34379](https://openairdocs.org/aircraft/N34379.md): Meyers MAC-145 · S/N 222 · Built 1956 · Gores Thomas
- [N3812A](https://openairdocs.org/aircraft/N3812A.md): Schweizer SGS 1-26B · S/N 83 · Built 1958 · Oconnor Sarah A
- [N3958Q](https://openairdocs.org/aircraft/N3958Q.md): Cessna 172L · S/N 17260058 · Built 1971 · Fisher Gregory S
- [N4624V](https://openairdocs.org/aircraft/N4624V.md): Cessna 172RG · S/N 172RG0342 · Fisher Gregory S
- [N569LC](https://openairdocs.org/aircraft/N569LC.md): Aerovodochody L-29 DELFIN · S/N 093816 · Esterle Miroslav M
- [N6323E](https://openairdocs.org/aircraft/N6323E.md): Cessna 172 · S/N 46423 · Built 1959 · Swedish Flying Couching LLC
- [N6721A](https://openairdocs.org/aircraft/N6721A.md): Cessna 172 · S/N 28821 · Rogers Jeffery D
- [N71126](https://openairdocs.org/aircraft/N71126.md): Cessna 182M · S/N 18259505 · Built 1968 · Overturf Andrew
- [N7195](https://openairdocs.org/aircraft/N7195.md): Bensen B-8M · S/N D7471215 · Built 1971 · Doers Douglas A
- [N80600](https://openairdocs.org/aircraft/N80600.md): Globe GC-1B · S/N 1005 · Built 1946 · Gores Thomas J
- [N822TW](https://openairdocs.org/aircraft/N822TW.md): Cirrus Design SR22 · S/N 1066 · Built 2004 · Woods Douglas A
- [N8375P](https://openairdocs.org/aircraft/N8375P.md): Piper PA-24-250 · S/N 24-3633 · Built 1964 · Gores Thomas J
- [N85790](https://openairdocs.org/aircraft/N85790.md): Aeronca 7AC · S/N 7AC-4540 · Built 1946 · Konstantakis George C
- [N8770P](https://openairdocs.org/aircraft/N8770P.md): Piper PA-24-260 · S/N 24-4220 · Gores Thomas J
- [N90DV](https://openairdocs.org/aircraft/N90DV.md): Doers Douglas A VELOCITY RG · S/N 81DV · Built 1991 · Doers Douglas A
- [N926G](https://openairdocs.org/aircraft/N926G.md): Chan Chui S RV-10 · S/N 41141 · Built 2017 · G2 Aviation LLC
- [N958EG](https://openairdocs.org/aircraft/N958EG.md): Hughes 269C · S/N 960547 · Built 1976 · Gores Thomas J

## 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 = 'FRANKLIN'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/WI/Franklin/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.
