# Registered aircraft: Schertz, TX

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

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

- [N101MU](https://openairdocs.org/aircraft/N101MU.md): Mooney M20J · S/N 24-3335 · Built 1994 · Red Bird And Outlaw LLC
- [N11MK](https://openairdocs.org/aircraft/N11MK.md): Piper J3C-65 · S/N 15748 · Built 1946 · Mckenney Robert N
- [N11XA](https://openairdocs.org/aircraft/N11XA.md): Luscombe 11E · S/N 11E-00996 · Built 2011 · Erwin Troy
- [N14909](https://openairdocs.org/aircraft/N14909.md): Bellanca 17-30A · S/N 74-30626 · Built 1973 · Johnson Bruce M
- [N232BA](https://openairdocs.org/aircraft/N232BA.md): Icon A5 · S/N 00019 · Ev Aviation LLC
- [N2485V](https://openairdocs.org/aircraft/N2485V.md): Cessna 140 · S/N 14754 · Built 1948 · Trayhan Edward J
- [N2487Y](https://openairdocs.org/aircraft/N2487Y.md): Cessna 172D · S/N 17249787 · Bradley Jeff C
- [N30PB](https://openairdocs.org/aircraft/N30PB.md): Krotje Peter R JABIRU J200 · S/N 14 · Built 2002 · Lunning John R
- [N33875](https://openairdocs.org/aircraft/N33875.md): Aeronca 65-CA · S/N C14061 · Built 1941 · Philippi Mack P
- [N34559](https://openairdocs.org/aircraft/N34559.md): Cessna 177B · S/N 17701874 · Built 1973 · Bagley John C
- [N3864L](https://openairdocs.org/aircraft/N3864L.md): Cessna 172 · S/N 17254033 · Built 1965 · Delvalle Dean
- [N4085B](https://openairdocs.org/aircraft/N4085B.md): Bellanca 17-30A · S/N 76-30821 · Built 1976 · Marroquin Jesse B DBA
- [N42894](https://openairdocs.org/aircraft/N42894.md): Cessna 182L · S/N 18259240 · Built 1968 · Comal Aero Inc
- [N45310](https://openairdocs.org/aircraft/N45310.md): Taylorcraft DCO-65 · S/N L-5762 · Built 1943 · Mioduski Dennis L
- [N457FS](https://openairdocs.org/aircraft/N457FS.md): Scottish SERIES 100 MDL 101 · S/N 129 · Meskimen Scott B
- [N5517Q](https://openairdocs.org/aircraft/N5517Q.md): Mooney M20C · S/N 2947 · Built 1965 · Trayhan Edward J
- [N593SX](https://openairdocs.org/aircraft/N593SX.md): Bruce M Johnson JOHNSON SONEX · S/N 593 · Johnson Bruce M
- [N601Z](https://openairdocs.org/aircraft/N601Z.md): Gates L V II/Gates C E CH601-HDS · S/N 6-3667 · Built 2004 · Mckenney Robert N Jr
- [N610JH](https://openairdocs.org/aircraft/N610JH.md): Hammons John M VANS RV-4 · S/N 860 · Built 1999 · Trayhan Edward J
- [N6440W](https://openairdocs.org/aircraft/N6440W.md): Piper PA-28-140 · S/N 28-20512 · Built 1964 · Mckenney Robert N
- [N6486U](https://openairdocs.org/aircraft/N6486U.md): Mooney M20C · S/N 2233 · Built 1962 · Dof Aviation Inc
- [N714KA](https://openairdocs.org/aircraft/N714KA.md): Foxair KITFOX LIGHT SPORT · S/N KA11007184 · Built 2011 · Foxy Flyers LLC
- [N7235V](https://openairdocs.org/aircraft/N7235V.md): Intermountain CALLAIR A-9 · S/N 1272 · Built 1966 · Hunter James Rogers
- [N738RM](https://openairdocs.org/aircraft/N738RM.md): Marsh Ralph L LIGHTNING · S/N 84 · Built 2010 · Miess Kenneth R
- [N74233](https://openairdocs.org/aircraft/N74233.md): Bellanca 14-13 · S/N 1346 · Built 1946 · Hunter James Rogers
- [N81606](https://openairdocs.org/aircraft/N81606.md): Aeronca 7AC · S/N 7AC227 · Built 1945 · Tanner R Joel
- [N8545R](https://openairdocs.org/aircraft/N8545R.md): Bellanca 14-19-3 · S/N 4307 · Built 1966 · Johnson Bruce M
- [N9286W](https://openairdocs.org/aircraft/N9286W.md): Piper PA-28-235 · S/N 28-10962 · Built 1967 · Amigos Flight Club LLC

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

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