# Registered aircraft: Smithville, OH

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

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

- [N13CM](https://openairdocs.org/aircraft/N13CM.md): Enstrom F-28A · S/N 090 · Built 1972 · Bolin William E
- [N19HC](https://openairdocs.org/aircraft/N19HC.md): Pitts S-2A · S/N 2266 · Built 1982 · Vista I Inc
- [N2438B](https://openairdocs.org/aircraft/N2438B.md): Temco GC-1B · S/N 3738 · Jentes Charles A
- [N2980L](https://openairdocs.org/aircraft/N2980L.md): Mooney M20F · S/N 670339 · First renewal notice · Built 1967 · Jentes Charles A
- [N2998L](https://openairdocs.org/aircraft/N2998L.md): Mooney M20C · S/N 670103 · Jentes Charles A
- [N321AW](https://openairdocs.org/aircraft/N321AW.md): Bell 206A · S/N 82 · Built 1967 · Bolin William E
- [N369AV](https://openairdocs.org/aircraft/N369AV.md): Hughes 369HS · S/N 110282-S · Built 1970 · Vista I Inc
- [N4971D](https://openairdocs.org/aircraft/N4971D.md): Cessna 182A · S/N 51071 · Built 1958 · Bolin William E
- [N5060B](https://openairdocs.org/aircraft/N5060B.md): Beech F35 · S/N D-4329 · Built 1955 · Bolin William E
- [N582JW](https://openairdocs.org/aircraft/N582JW.md): Eric De Horta DRIFTER MU582 · S/N 007 · De Horta Eric
- [N7161Q](https://openairdocs.org/aircraft/N7161Q.md): Cessna 172L · S/N 17260461 · Built 1972 · Frigate Aviation LLC
- [N7371W](https://openairdocs.org/aircraft/N7371W.md): Piper PA-28-180 · S/N 28-1253 · Built 1963 · Vista I Inc
- [N7776X](https://openairdocs.org/aircraft/N7776X.md): Cessna 172B · S/N 17248276 · Built 1961 · Vista I Inc
- [N77GG](https://openairdocs.org/aircraft/N77GG.md): Guthan ACRODUSTER SA 750 · S/N 1-77-BG · Built 1979 · Coben Craig S
- [N9140L](https://openairdocs.org/aircraft/N9140L.md): Champion 7ECA · S/N 807-71 · Built 1971 · Pretorius Ellen T
- [N9326V](https://openairdocs.org/aircraft/N9326V.md): Mooney M20F · S/N 700002 · Built 1969 · Sprang Bob E
- [N936SC](https://openairdocs.org/aircraft/N936SC.md): Schultz Jack RV4 · S/N 936 · Built 1988 · Sprang Robert

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

This list as a web page: https://openairdocs.org/faa-place/OH/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, except the copies of manufacturers’ service documents, which belong to their rights holders.