# Registered aircraft: Winfield, KS

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

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

- [N1632G](https://openairdocs.org/aircraft/N1632G.md): Champion 7ECA · S/N 627 · Built 1968 · Valentine Robert D
- [N2050S](https://openairdocs.org/aircraft/N2050S.md): Cessna T210L · S/N 21061017 · Built 1975 · Davis Bryan C
- [N2092V](https://openairdocs.org/aircraft/N2092V.md): Cessna 140 · S/N 14304 · Built 1947 · Davis Bryan C
- [N2190V](https://openairdocs.org/aircraft/N2190V.md): DJI AGRAS T40 · S/N 64TBL2100200H3 · Valentine Bobby
- [N3328Q](https://openairdocs.org/aircraft/N3328Q.md): Piper PA-28-140 · S/N 28-7725223 · Built 1977 · Eastman John T
- [N3407Z](https://openairdocs.org/aircraft/N3407Z.md): Piper PA-22-150 · S/N 22-7319 · Bug Smashers LLC
- [N367G](https://openairdocs.org/aircraft/N367G.md): Daryl Rhodes BEARHAWK · S/N L-176 · Built 2019 · Rhodes Daryl R
- [N475DG](https://openairdocs.org/aircraft/N475DG.md): Gingerich David F WOODY PUSHER WAS2-DG · S/N 001 · Built 1989 · Bug Smashers LLC
- [N5572G](https://openairdocs.org/aircraft/N5572G.md): Cessna 150J · S/N 15071072 · Built 1969 · Bug Smashers LLC
- [N558YR](https://openairdocs.org/aircraft/N558YR.md): Daryl Rhodes EASY EAGLE · S/N 022107-103 · Built 2015 · Rhodes Daryl R
- [N596NE](https://openairdocs.org/aircraft/N596NE.md): Hamsa Raj X-AIR HANUMAN · S/N 1118 · Bug Smashers LLC
- [N603CT](https://openairdocs.org/aircraft/N603CT.md): Flight Design CTSW · S/N 05-06-03 · Built 2005 · Bug Smashers LLC
- [N604HA](https://openairdocs.org/aircraft/N604HA.md): Hispano Aviacion HA-200 SAETA · S/N E.14A-4 · Davis Bryan
- [N71230](https://openairdocs.org/aircraft/N71230.md): Luscombe 8A · S/N 2657 · Built 1946 · Hopper Jerry L
- [N739VG](https://openairdocs.org/aircraft/N739VG.md): Cessna 172N · S/N 17270836 · Built 1978 · Hopper Oil Co Inc
- [N756SE](https://openairdocs.org/aircraft/N756SE.md): Cessna TR182 · S/N R18201143 · Built 1979 · Notus LLC
- [N7610D](https://openairdocs.org/aircraft/N7610D.md): Piper PA-22-150 · S/N 22-5312 · Bug Smashers LLC
- [N8079W](https://openairdocs.org/aircraft/N8079W.md): Piper PA-28-180 · S/N 28-2168 · Built 1965 · Fox Michael
- [N9032W](https://openairdocs.org/aircraft/N9032W.md): Piper PA-28-235 · S/N 28-10624 · Pringle Craig Marlin
- [N93963](https://openairdocs.org/aircraft/N93963.md): Ercoupe 415-C · S/N 1286 · Built 1946 · Bug Smashers LLC
- [N9424D](https://openairdocs.org/aircraft/N9424D.md): Piper PA-22-150 · S/N 22-6398 · Built 1958 · Branch Clayton L
- [N9434V](https://openairdocs.org/aircraft/N9434V.md): Mooney M20C · S/N 700046 · Built 1970 · Knackstedt Dennis R
- [N9563W](https://openairdocs.org/aircraft/N9563W.md): Piper PA-28-140 · S/N 28-23000 · Built 1967 · Eastside Development Co 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 = 'KS' AND g.registrant_city = 'WINFIELD'
ORDER BY g.n_number
```

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