# Registered aircraft: Goshen, OH

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

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

- [N117F](https://openairdocs.org/aircraft/N117F.md): Smith AEROSTAR 601P · S/N 61P0442167 · A Lot Of Gas LLC
- [N1330E](https://openairdocs.org/aircraft/N1330E.md): Aeronca 7AC · S/N 7AC-4891 · Built 1946 · Ely Scott K
- [N2237L](https://openairdocs.org/aircraft/N2237L.md): Beech C23 · S/N M1885 · Built 1976 · Deatherage Christina M
- [N284NA](https://openairdocs.org/aircraft/N284NA.md): DJI AGRAS T50 · S/N 1581F6BUB247S001C46J · Moeller David
- [N29372](https://openairdocs.org/aircraft/N29372.md): Waco VKS-7 · S/N 5230 · Built 1940 · Byars Guy F
- [N30508](https://openairdocs.org/aircraft/N30508.md): Piper J5A · S/N 5-204 · Built 1940 · Byars Guy F
- [N3975B](https://openairdocs.org/aircraft/N3975B.md): Boeing E75N1 · S/N 75-8331 · Built 1942 · Lines Charles H
- [N427WT](https://openairdocs.org/aircraft/N427WT.md): Wooden Jim PITTS MODEL 12 · S/N 081 · Built 2007 · Diamond Machine Tool LLC
- [N493CK](https://openairdocs.org/aircraft/N493CK.md): Mark Steven Taylor HATZ CB-1 · S/N 493 · Built 2012 · Taylor Mark Steven
- [N52DW](https://openairdocs.org/aircraft/N52DW.md): S C Aerostar S A YAK-52TW · S/N 0312410 · Built 2003 · Hodge Jay
- [N591TX](https://openairdocs.org/aircraft/N591TX.md): Andrew Schechter PITTS SIT · S/N 001 · Built 2022 · Schechter Andrew M
- [N6567Y](https://openairdocs.org/aircraft/N6567Y.md): Cessna T210N · S/N 21064442 · Built 1981 · Moeller Gerhard Walter
- [N70849](https://openairdocs.org/aircraft/N70849.md): Cessna 182M · S/N 18259393 · Hedrick Chad A
- [N726HB](https://openairdocs.org/aircraft/N726HB.md): Luscombe 8E · S/N 4561 · Deatherage Tony
- [N750RE](https://openairdocs.org/aircraft/N750RE.md): Richard S Carpenter CH 750 CRUZER · S/N C75-10111 · Carpenter Richard S
- [N77345](https://openairdocs.org/aircraft/N77345.md): Cessna 140 · S/N 11786 · Taylor Mark S
- [N8633K](https://openairdocs.org/aircraft/N8633K.md): Stinson 108-1 · S/N 108-1633 · Built 1947 · Harper Michael S
- [N917WV](https://openairdocs.org/aircraft/N917WV.md): Schempp-Hirth DISCUS-2B · S/N 81 · Built 2000 · Byars Guy F
- [N91840](https://openairdocs.org/aircraft/N91840.md): Schweizer SGU-1-20 · S/N 1 · Byars Guy F
- [N918GC](https://openairdocs.org/aircraft/N918GC.md): Yakovlev YAK 18T · S/N 22202034062 · Built 1979 · Driscoll Patrick
- [N952GS](https://openairdocs.org/aircraft/N952GS.md): Grumman American Avn. AA-1B · S/N AA1B-0434 · Built 1974 · Stiffler Gary C

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

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