# Registered aircraft: Lima, OH

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

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

- [N135TS](https://openairdocs.org/aircraft/N135TS.md): Cessna T206H · S/N T20608413 · Built 2003 · N135ts LLC
- [N150JW](https://openairdocs.org/aircraft/N150JW.md): Cessna 150G · S/N 15065680 · Built 1966 · Sheely Kevin L
- [N15204](https://openairdocs.org/aircraft/N15204.md): Piper PA-28-180 · S/N 28-7305035 · Built 1972 · Arthur Jeffery L
- [N16496](https://openairdocs.org/aircraft/N16496.md): Piper PA-28-180 · S/N 28-7305270 · Built 1973 · Gesler Mark A DBA
- [N188SE](https://openairdocs.org/aircraft/N188SE.md): Piper PA-32RT-300 · S/N 32R-7885255 · Built 1978 · Chernov Boris
- [N241KF](https://openairdocs.org/aircraft/N241KF.md): Smith Richard L S-14 · S/N 01-13 · Built 2013 · Davis Roy W
- [N247SK](https://openairdocs.org/aircraft/N247SK.md): Pilatus PC-12/47G · S/N 3026 · Built 2025 · Schaub Aviation Ltd
- [N28RH](https://openairdocs.org/aircraft/N28RH.md): Cessna 421C · S/N 421C0847 · Built 1980 · National Airplane Sales & Leasing Corp
- [N3245E](https://openairdocs.org/aircraft/N3245E.md): Aeronca 11AC · S/N 11AC-1596 · Built 1947 · Pisle John D
- [N3911R](https://openairdocs.org/aircraft/N3911R.md): Cessna 172H · S/N 17255411 · Purcell Keith A
- [N4151G](https://openairdocs.org/aircraft/N4151G.md): Cessna 340A · S/N 340A0321 · 4151g LLC
- [N4534X](https://openairdocs.org/aircraft/N4534X.md): Piper PA-28R-200 · S/N 28R-7635071 · Built 1975 · 4534xray Flyers Ltd
- [N5054T](https://openairdocs.org/aircraft/N5054T.md): Cessna T206H · S/N T20608906 · Built 2009 · Webb Larry R
- [N5255A](https://openairdocs.org/aircraft/N5255A.md): Cessna 210N · S/N 21063329 · Built 1979 · Bishop Michael J
- [N5313R](https://openairdocs.org/aircraft/N5313R.md): Cameron Balloons O-77 · S/N 6152 · Built 1998 · Cusick Richard J
- [N67SA](https://openairdocs.org/aircraft/N67SA.md): Cirrus Design SR22 · S/N 0978 · Built 2004 · E And J Medical Consulting LLC
- [N689V](https://openairdocs.org/aircraft/N689V.md): Beech 35-33 · S/N CD-110 · Built 1960 · Arthur Jeffery L
- [N735P](https://openairdocs.org/aircraft/N735P.md): Beech 58 · S/N TH-981 · Built 1978 · Two J Aviation LLC
- [N76J](https://openairdocs.org/aircraft/N76J.md): Beech J35 · S/N D-5616 · Built 1958 · Mayer Kevin D
- [N78197](https://openairdocs.org/aircraft/N78197.md): Cessna 172K · S/N 17257523 · Built 1968 · Allen County Regional Airport Authority
- [N840CS](https://openairdocs.org/aircraft/N840CS.md): Robinson Helicopter R44 · S/N 0326 · Built 1997 · Miller Ashley M
- [N9228V](https://openairdocs.org/aircraft/N9228V.md): Mooney M20E · S/N 690049 · Built 1969 · Duval James A
- [N9239D](https://openairdocs.org/aircraft/N9239D.md): Piper PA-32R-301 · S/N 3213071 · Built 1994 · Misson Aviation LLC
- [N994TB](https://openairdocs.org/aircraft/N994TB.md): Gesler Mark A TAYLORBIRD · S/N TB002 · Built 2000 · Gesler Mark A

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

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