# Registered aircraft: Clifton, TX

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

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

- [N1738F](https://openairdocs.org/aircraft/N1738F.md): Cessna 172H · S/N 17255133 · Built 1966 · Wesley Emerson Holdings LLC
- [N17632](https://openairdocs.org/aircraft/N17632.md): Beech F33A · S/N CE-697 · Built 1977 · Hunt Elizabeth H
- [N250TJ](https://openairdocs.org/aircraft/N250TJ.md): Piper PA-24-250 · S/N 24-1048 · Built 1959 · Talley John T
- [N3HM](https://openairdocs.org/aircraft/N3HM.md): Piper PA-24-260 · S/N 24-4277 · Built 1965 · Talley John T
- [N4087K](https://openairdocs.org/aircraft/N4087K.md): Piper PA-31-350 · S/N 31-8152129 · Built 1981 · Aggie Air Inc
- [N6351X](https://openairdocs.org/aircraft/N6351X.md): Beech 58 · S/N TH-1312 · Gilles David L
- [N6608R](https://openairdocs.org/aircraft/N6608R.md): Cessna 172RG · S/N 172RG0210 · Built 1979 · Bogovich Robert E
- [N6737A](https://openairdocs.org/aircraft/N6737A.md): Cessna 172 · S/N 28837 · Built 1956 · Edmiston Dave L
- [N7124P](https://openairdocs.org/aircraft/N7124P.md): Piper PA-24-250 · S/N 24-2284 · Built 1961 · Talley John T
- [N7361R](https://openairdocs.org/aircraft/N7361R.md): Cessna TR182 · S/N R18200647 · Built 1978 · Mcafee Scott A Trustee
- [N800LP](https://openairdocs.org/aircraft/N800LP.md): Piper PA-31-350 · S/N 31-8352009 · Built 1983 · C A Aviation Corp
- [N8155Y](https://openairdocs.org/aircraft/N8155Y.md): Piper PA-30 · S/N 30-1269 · Talley John T
- [N903PS](https://openairdocs.org/aircraft/N903PS.md): Cirrus Design SR20 · S/N 2662 · Built 2021 · Wesley Emerson Holdings LLC
- [N904XC](https://openairdocs.org/aircraft/N904XC.md): Bowles Chris ZENITH 801 · S/N 84096 · Built 2009 · Harmon Philip E
- [N952WT](https://openairdocs.org/aircraft/N952WT.md): Vans RV-12 · S/N 120223 · Built 2017 · Hoff John M
- [N973CC](https://openairdocs.org/aircraft/N973CC.md): Cub Crafters CC11-100 · S/N CC11-00075 · Built 2008 · Talley John T
- [N9799T](https://openairdocs.org/aircraft/N9799T.md): Cessna 172A · S/N 47599 · Built 1960 · Deapen Jordan Derek

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

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