# Registered aircraft: Jamestown, OH

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

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

- [N103TS](https://openairdocs.org/aircraft/N103TS.md): Degraff Irwin KOLB MK III · S/N M3/003 · Built 1992 · Kilbarger Shawn R
- [N1157M](https://openairdocs.org/aircraft/N1157M.md): Cessna 182P · S/N 18264235 · Built 1975 · Whf Aviation LLC
- [N33444](https://openairdocs.org/aircraft/N33444.md): Piper PA-28-180 · S/N 28-7505146 · Built 1975 · Mossbarger Beverly Jo
- [N3585E](https://openairdocs.org/aircraft/N3585E.md): Aeronca 7AC · S/N 7AC-6926 · Built 1947 · Davenport Dewey D
- [N455N](https://openairdocs.org/aircraft/N455N.md): Curtiss Wright TRAVEL AIR D-4000 · S/N 1361 · Triple D Aviation LLC
- [N45790](https://openairdocs.org/aircraft/N45790.md): Mcpherson VARI-EZE · S/N 559 · Kilbarger Shawn
- [N46343](https://openairdocs.org/aircraft/N46343.md): Miller Robert SUPER QUICKIE Q1 · S/N RWM-SQ1 · Built 2005 · Kilbarger Shawn R
- [N6223F](https://openairdocs.org/aircraft/N6223F.md): Russell A Turner SOPWITH CAMEL · S/N F6223 · Turner Russell A
- [N6260](https://openairdocs.org/aircraft/N6260.md): DJI AGRAS T40 · S/N 64TBKAF00200GD · Aero Ag Command LLC
- [N637DC](https://openairdocs.org/aircraft/N637DC.md): DJI T40 · S/N 1581F574B239100100F2 · Thompson Grain Farm Gp
- [N639DC](https://openairdocs.org/aircraft/N639DC.md): DJI T40 · S/N 1581F574B239600100LW · Thompson Grain Farm Gp
- [N6490](https://openairdocs.org/aircraft/N6490.md): DJI AGRAS T40 · S/N 64TBKAA001018D · Aero Ag Command LLC
- [N67AC](https://openairdocs.org/aircraft/N67AC.md): DJI T20P · S/N 64UBL5P002006L · Aero Ag Command LLC
- [N8715H](https://openairdocs.org/aircraft/N8715H.md): North American NAVION · S/N NAV-4-715 · Built 1947 · Combs Gardner J
- [N928V](https://openairdocs.org/aircraft/N928V.md): White NEW STANDARD D-25 · S/N 154 · Built 1929 · Triple D Aviation LLC
- [N937SK](https://openairdocs.org/aircraft/N937SK.md): Kilbarger Shawn SPRINT II · S/N 9955 · Built 2003 · Kilbarger Shawn

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

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