# Registered aircraft: Vernon, TX

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

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

- [N14695](https://openairdocs.org/aircraft/N14695.md): Bellanca 17-30A · S/N 74-30688 · Built 1974 · Johnson Charles E
- [N2447R](https://openairdocs.org/aircraft/N2447R.md): Piper PA-28-180 · S/N 28-5623 · Built 1969 · Gift Academy Inc
- [N2669E](https://openairdocs.org/aircraft/N2669E.md): Aeronca 7CCM · S/N 7CCM-111 · Built 1948 · Screws Harlan D
- [N30453](https://openairdocs.org/aircraft/N30453.md): Cessna T210L · S/N 21059923 · Built 1973 · Lehman Land Management LLC
- [N3245L](https://openairdocs.org/aircraft/N3245L.md): Cessna 172H · S/N 17256145 · Built 1967 · Gift Academy Inc
- [N369CS](https://openairdocs.org/aircraft/N369CS.md): Powrachute PEGASUS · S/N A461PEG · Built 2008 · Streit Freddie H
- [N3D](https://openairdocs.org/aircraft/N3D.md): Bell 206B · S/N 4620 · Built 2007 · W T Waggoner Estates
- [N4151V](https://openairdocs.org/aircraft/N4151V.md): Cessna 170 · S/N 18483 · Risner Rick
- [N492FL](https://openairdocs.org/aircraft/N492FL.md): Piper PA-28-140 · S/N 28-7125306 · Built 1971 · Mcknight Anna Mae
- [N5236S](https://openairdocs.org/aircraft/N5236S.md): Air Tractor AT-301 · S/N 301-0130 · Built 1978 · Morrison Lynn
- [N5896U](https://openairdocs.org/aircraft/N5896U.md): Piper PA-28-140 · S/N 28-26792 · Gift Academy Inc
- [N6106U](https://openairdocs.org/aircraft/N6106U.md): Air Tractor AT-401B · S/N 401B-0976 · Registration pending · Built 1995
- [N6174P](https://openairdocs.org/aircraft/N6174P.md): Piper PA-24-250 · S/N 24-1275 · Built 1959 · Abernathy Larry D
- [N6323J](https://openairdocs.org/aircraft/N6323J.md): Piper PA-28-180 · S/N 28-4731 · Young Troy D
- [N66526](https://openairdocs.org/aircraft/N66526.md): Cessna 150M · S/N 15076101 · Built 1974 · Latimer Lawrence A
- [N73127](https://openairdocs.org/aircraft/N73127.md): Air Tractor AT-400A · S/N 301-0667 · Built 1987 · Georges Aircraft Repair
- [N803LM](https://openairdocs.org/aircraft/N803LM.md): Air Tractor AT-802A · S/N 802A-0663 · Built 2016 · Morrison Lynn
- [N82609](https://openairdocs.org/aircraft/N82609.md): Aeronca 7DC · S/N 7AC-1249 · Built 1946 · Screws Harlan D
- [N8285R](https://openairdocs.org/aircraft/N8285R.md): Bellanca 17-30A · S/N 30466 · Built 1972 · Latimer Mark A
- [N8618L](https://openairdocs.org/aircraft/N8618L.md): Piper PA-25-235 · S/N 25-5047 · Built 1969 · Latimer Lawrence A
- [N8767N](https://openairdocs.org/aircraft/N8767N.md): Piper PA-28-140 · S/N 28-25591 · Built 1969 · Abernathy Larry D

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

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