# Registered aircraft: Amelia, OH

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

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

- [N11CY](https://openairdocs.org/aircraft/N11CY.md): Grumman American Avn. AA-1C · S/N AA1C-0011 · Odonnell Justin M
- [N1531Z](https://openairdocs.org/aircraft/N1531Z.md): Beech 95-A55 · S/N TC-205 · Built 1961 · Shenandoah Whalen
- [N200EH](https://openairdocs.org/aircraft/N200EH.md): Enstrom F-28A · S/N 200 · Built 1974 · D & M Aviation Inc
- [N247JH](https://openairdocs.org/aircraft/N247JH.md): Learjet 45 · S/N 344 · Built 2007 · Wair Next LLC
- [N253DC](https://openairdocs.org/aircraft/N253DC.md): Enstrom 280FX · S/N 2053 · D & M Aviation Inc
- [N2620C](https://openairdocs.org/aircraft/N2620C.md): Robinson Helicopter R22 BETA · S/N 0725 · Built 1987 · Whalen Shenandoah
- [N2TB](https://openairdocs.org/aircraft/N2TB.md): Republic RC-3 · S/N 819 · Built 1947 · Whalen Shenandoah
- [N3925T](https://openairdocs.org/aircraft/N3925T.md): Piper PA-28R-180 · S/N 28R-30263 · Built 1967 · Elevation Air LLC
- [N4225H](https://openairdocs.org/aircraft/N4225H.md): Haley Bernard H H-2-E · S/N H01E · Haley Bernard H
- [N4225J](https://openairdocs.org/aircraft/N4225J.md): Haley Bernard H H-1 E · S/N H01E · Haley Bernard H
- [N48752](https://openairdocs.org/aircraft/N48752.md): Ryan Aeronautical ST3KR · S/N 1427 · Built 1941 · Durkee Michael S
- [N4933L](https://openairdocs.org/aircraft/N4933L.md): Piper PA-28-180 · S/N 28-4301 · Southall Charles B
- [N51122](https://openairdocs.org/aircraft/N51122.md): Ryan Aeronautical ST3KR · S/N 2204 · Built 1942 · Durkee Michael S
- [N56U](https://openairdocs.org/aircraft/N56U.md): Enstrom F-28A · S/N 139 · D&M Aviation Inc
- [N6158D](https://openairdocs.org/aircraft/N6158D.md): Dirr Donald W CHALLENGER II · S/N CH2-0294-1089 · Built 1994 · Haley Bernard H
- [N74533](https://openairdocs.org/aircraft/N74533.md): Mooney M20B · S/N 1844 · Built 1961 · Whalen Shenandoah
- [N754MH](https://openairdocs.org/aircraft/N754MH.md): Enstrom 280 · S/N 1024 · D&M Aviation Inc
- [N8583M](https://openairdocs.org/aircraft/N8583M.md): Beech 35-B33 · S/N CD-652 · Whalen Shenandoah
- [N87564](https://openairdocs.org/aircraft/N87564.md): Republic RC-3 · S/N 126 · Built 1946 · Whalen Shenandoah
- [N9818R](https://openairdocs.org/aircraft/N9818R.md): Beech M35 · S/N D-6323 · Built 1960 · Durkee Michael S

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

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