# Registered aircraft: Smithville, TX

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

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

- [N1624W](https://openairdocs.org/aircraft/N1624W.md): Beech F33A · S/N CE-384 · Built 1972 · Hill Travis
- [N168P](https://openairdocs.org/aircraft/N168P.md): Ercoupe 415-C · S/N 905 · Built 1946 · Mcmanus Brian K
- [N20205](https://openairdocs.org/aircraft/N20205.md): Streese Roger L KOLB TWINSTAR MK III · S/N M3-196 · Built 1996 · Vinklarek Robert E
- [N280AM](https://openairdocs.org/aircraft/N280AM.md): Aircraft Mfg & Development CH 2000 · S/N 20-1041 · Built 2004 · Sabol John
- [N3414P](https://openairdocs.org/aircraft/N3414P.md): Piper PA-18 · S/N 18-6772 · Built 1958 · Hilil Inc
- [N4288V](https://openairdocs.org/aircraft/N4288V.md): Cessna 170 · S/N 18646 · Built 1948 · Peck Kenneth L
- [N4773Z](https://openairdocs.org/aircraft/N4773Z.md): Piper PA-22-108 · S/N 22-8334 · Built 1961 · Lockaby Jess
- [N499TK](https://openairdocs.org/aircraft/N499TK.md): Timothy M Keaten CH 750 CRUZER · S/N C75-11021 · Built 2024 · Gober Billy J
- [N6200W](https://openairdocs.org/aircraft/N6200W.md): Piper PA-28-140 · S/N 28-20232 · Built 1964 · Graves Jeffrey D
- [N62502](https://openairdocs.org/aircraft/N62502.md): Cessna 172P · S/N 17275284 · Hill Andrew T
- [N63451](https://openairdocs.org/aircraft/N63451.md): Cessna 150M · S/N 15077324 · Built 1975 · Sterling James E
- [N709TX](https://openairdocs.org/aircraft/N709TX.md): Sportflight Intl LLC-Stellar A ASTRA 912 · S/N A0702308R · Built 2007 · Learmonth Darren S
- [N759UU](https://openairdocs.org/aircraft/N759UU.md): Cessna 182Q · S/N 18266277 · Built 1978 · Meyerson Sanford
- [N9003V](https://openairdocs.org/aircraft/N9003V.md): Beech V35A · S/N D-8907 · Mann Spencer I
- [N9077J](https://openairdocs.org/aircraft/N9077J.md): Piper PA-28-180 · S/N 28-3113 · Built 1966 · Streuer Troy
- [N94ER](https://openairdocs.org/aircraft/N94ER.md): Cessna 172P · S/N 17276053 · Built 1983 · Hill Andrew T

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

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