# Registered aircraft: Medford, WI

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

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

- [N1228B](https://openairdocs.org/aircraft/N1228B.md): Luscombe 8A · S/N 5855 · Built 1947 · Erl Don L
- [N1555B](https://openairdocs.org/aircraft/N1555B.md): Silvaire LUSCOMBE 8E · S/N 6182 · Built 1948 · Lee Robert E
- [N2026B](https://openairdocs.org/aircraft/N2026B.md): Luscombe 8A · S/N 6453 · Built 1948 · Lee Robert E
- [N2426X](https://openairdocs.org/aircraft/N2426X.md): Cessna 182H · S/N 18256326 · Built 1965 · Colwell Patrick R Jr
- [N250DR](https://openairdocs.org/aircraft/N250DR.md): DJI AGRAS T50 · S/N 1581F6BUB246L00172VH · Dr Drone LLC
- [N256DR](https://openairdocs.org/aircraft/N256DR.md): DJI AGRAS T40 · S/N 1581F574B2385001008E · Dr Drone LLC
- [N2993K](https://openairdocs.org/aircraft/N2993K.md): Luscombe 8E · S/N 5720 · Built 1947 · Lee Robert E
- [N31126](https://openairdocs.org/aircraft/N31126.md): Piper J3C-85 · S/N 5346 · Built 1940 · Krug Gene G
- [N34BH](https://openairdocs.org/aircraft/N34BH.md): Hall William A SLING 2 · S/N 291K · Built 2019 · Hall William A
- [N3789K](https://openairdocs.org/aircraft/N3789K.md): Universal GLOBE GC-1B · S/N 1482 · Lee Robert E
- [N38686](https://openairdocs.org/aircraft/N38686.md): Piper J3L-65 · S/N 7194 · Jones Gordon B
- [N3869R](https://openairdocs.org/aircraft/N3869R.md): Cessna 172H · S/N 17255369 · Built 1966 · Erl Don L
- [N4349B](https://openairdocs.org/aircraft/N4349B.md): Cessna 170B · S/N 26693 · Built 1955 · Lee Robert E
- [N438JE](https://openairdocs.org/aircraft/N438JE.md): Engle John E SR RANS S-6S · S/N 11041621 · Built 2007 · Machon Brett
- [N448PS](https://openairdocs.org/aircraft/N448PS.md): Talos Drones T60X · S/N 2104F7EZW255P0015N2A · Bam Agricultural Spraying And Services LLC
- [N45628](https://openairdocs.org/aircraft/N45628.md): Luscombe 8A · S/N 2155 · Erl Don L
- [N50484](https://openairdocs.org/aircraft/N50484.md): Cessna 172M · S/N 17264205 · Built 1974 · Freudenthal Jack J
- [N5282T](https://openairdocs.org/aircraft/N5282T.md): Piper PA-28R-200 · S/N 28R-7235215 · Built 1972 · Mehlberg Jerry L
- [N6104F](https://openairdocs.org/aircraft/N6104F.md): Mader Allen J CHALLENGER II · S/N 1933 · Built 2000 · Mader Allen Joseph
- [N6376E](https://openairdocs.org/aircraft/N6376E.md): Cessna 172 · S/N 46476 · Built 1959 · Zawacki William M
- [N6516S](https://openairdocs.org/aircraft/N6516S.md): Cessna 150H · S/N 15067316 · Lee Robert E
- [N65RK](https://openairdocs.org/aircraft/N65RK.md): GKW Club HATZ CB-1 · S/N 75 · Built 1989 · Lee Robert E
- [N71275](https://openairdocs.org/aircraft/N71275.md): Luscombe 8A · S/N 2702 · Built 1946 · Lee Robert E
- [N7552E](https://openairdocs.org/aircraft/N7552E.md): Champion 7FC · S/N 7FC-253 · Built 1958 · Bouchard Scott A
- [N8292T](https://openairdocs.org/aircraft/N8292T.md): Piper PA-32R-301T · S/N 32R-8329001 · Built 1982 · James Peterson Sons Inc
- [N843MW](https://openairdocs.org/aircraft/N843MW.md): DJI AGRAS T50 · S/N 63YBM6J002006B · Sale reported
- [N85774](https://openairdocs.org/aircraft/N85774.md): Aeronca 7AC · S/N 7AC-4523 · Built 1963 · Peterson Jeffery John
- [N9023T](https://openairdocs.org/aircraft/N9023T.md): Cessna 182C · S/N 52923 · Built 1960 · Bauer John P

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

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