# Registered aircraft: Winnie, TX

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

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

- [N175LA](https://openairdocs.org/aircraft/N175LA.md): Air Tractor AT-802A · S/N 802A-0175 · Built 2004 · Mitchell Andrew D Trustee
- [N21124](https://openairdocs.org/aircraft/N21124.md): Cessna 172M · S/N 17263894 · Built 1974 · Mitchell Andrew D Trustee
- [N334BS](https://openairdocs.org/aircraft/N334BS.md): Air Tractor AT-802A · S/N 802A-0521 · Mitchell Andrew D Trustee
- [N388AG](https://openairdocs.org/aircraft/N388AG.md): Cessna 182N · S/N 18260122 · Built 1969 · Glenn Alan K
- [N401CL](https://openairdocs.org/aircraft/N401CL.md): Compagnie Daher TBM 700 · S/N 1452 · Built 2022 · Griffith Carl Ray Jr
- [N42590](https://openairdocs.org/aircraft/N42590.md): Air Tractor AT-602 · S/N 602-1181 · Built 2009 · Twin County Air-Ag Inc
- [N532DP](https://openairdocs.org/aircraft/N532DP.md): DJI AGRAS T40 · S/N 1581F574B23AM001000W · Registration pending
- [N579CT](https://openairdocs.org/aircraft/N579CT.md): Flight Design CTSW · S/N 07-05-09 · Built 2007 · Hunt Kevin W
- [N602MH](https://openairdocs.org/aircraft/N602MH.md): Air Tractor AT-602 · S/N 602-1218 · Built 2012 · Twin County Air-Ag Inc
- [N624KS](https://openairdocs.org/aircraft/N624KS.md): Airbus Helicopters AS350B2 · S/N 2183 · Built 1989 · Aerial Coalition Surveillance LLC
- [N64952](https://openairdocs.org/aircraft/N64952.md): Boeing E75 · S/N 75-637 · East Chambers Ag Historical Society
- [N802SH](https://openairdocs.org/aircraft/N802SH.md): Air Tractor AT-802A · S/N 802A-0750 · Built 2018 · Mitchell Andrew D Trustee
- [N805ET](https://openairdocs.org/aircraft/N805ET.md): Air Tractor AT-802A · S/N 802A-0481 · Built 2012 · Arc Aviation Of Texas LLC
- [N8524H](https://openairdocs.org/aircraft/N8524H.md): Air Tractor AT-802A · S/N 802A-0163 · Mitchell Andrew D Trustee
- [N8583S](https://openairdocs.org/aircraft/N8583S.md): Cessna 182H · S/N 18256683 · Built 1965 · Devillier Roland James
- [N9086G](https://openairdocs.org/aircraft/N9086G.md): Cessna 182N · S/N 18260626 · Built 1971 · Wilcox Leo Morgan

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

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