# Registered aircraft: Winterset, IA

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

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

- [N1348P](https://openairdocs.org/aircraft/N1348P.md): Hiller UH-12C · S/N 892 · Carey James D
- [N171WB](https://openairdocs.org/aircraft/N171WB.md): Cessna 182P · S/N 18264036 · Built 1975 · Yeager Hal J
- [N2067G](https://openairdocs.org/aircraft/N2067G.md): Cessna 182A · S/N 51367 · Yeager Hal J
- [N2068](https://openairdocs.org/aircraft/N2068.md): DJI AGRAS T20P · S/N 1581F574B237W001018V · Rasmus Robert
- [N2372Q](https://openairdocs.org/aircraft/N2372Q.md): Beech 23 · S/N M-445 · Built 1963 · Black Stephen L
- [N267MY](https://openairdocs.org/aircraft/N267MY.md): DJI AGRAS T30 · S/N 3TNDJ6J002PNUM · Goodridge Greg L
- [N267QT](https://openairdocs.org/aircraft/N267QT.md): DJI AGRAS T30 · S/N 3TNDJ6J002HN9J · Goodridge Greg L
- [N279FQ](https://openairdocs.org/aircraft/N279FQ.md): DJI AGRAS T20P · S/N 1581F574B237W00100VB · Cook Pat
- [N279HP](https://openairdocs.org/aircraft/N279HP.md): DJI AGRAS T40 · S/N 1581F574B2274001015F · Cook Pat
- [N29618](https://openairdocs.org/aircraft/N29618.md): Woolery Robert W L4H · S/N 1943 · Built 2008 · N9297q Inc
- [N3351F](https://openairdocs.org/aircraft/N3351F.md): Hiller UH-12E · S/N 1207 · Built 1960 · Carey James D
- [N3428R](https://openairdocs.org/aircraft/N3428R.md): Piper PA-28-180 · S/N 28-5678 · Lagrange David F
- [N57CD](https://openairdocs.org/aircraft/N57CD.md): Hiller UH-12C · S/N 878 · Built 1957 · Carey James Dean
- [N5841D](https://openairdocs.org/aircraft/N5841D.md): Piper PA-22-150 · S/N 22-4520 · Built 1956 · Leopold Gary L
- [N64AJ](https://openairdocs.org/aircraft/N64AJ.md): Cessna 180J · S/N 18052364 · N64aj LLC
- [N654HS](https://openairdocs.org/aircraft/N654HS.md): Eavision EA-J70 · S/N JMZKJ070UAV612555492 · Cedar Crest Solutions LLC
- [N7000H](https://openairdocs.org/aircraft/N7000H.md): National Ballooning 858 · S/N 126 · National Ballooning Ltd
- [N733RA](https://openairdocs.org/aircraft/N733RA.md): Cessna 172N · S/N 17268479 · Built 1976 · Lilly Daryl A
- [N75734](https://openairdocs.org/aircraft/N75734.md): T-Bird T-BIRD I · S/N T-BIRDI-TG100561 · Built 2002 · Lilly Daryl A
- [N7875R](https://openairdocs.org/aircraft/N7875R.md): Beech V35A · S/N D-8934 · Built 1969 · Johnson Joel Andrew
- [N8863](https://openairdocs.org/aircraft/N8863.md): Ackerman John P RV-10 · S/N 40458 · Built 2010 · Lilly Daryl A
- [N9025N](https://openairdocs.org/aircraft/N9025N.md): Leopold H/Leopold G WARNER SPORTSTER · S/N 50102 · Leopold Gary L

## 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 = 'IA' AND g.registrant_city = 'WINTERSET'
ORDER BY g.n_number
```

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