# Registered aircraft: Fairfield, OH

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

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

- [N100MB](https://openairdocs.org/aircraft/N100MB.md): Dassault FALCON 2000EX · S/N 60 · Built 2005 · Mb Aviation Corp
- [N14052](https://openairdocs.org/aircraft/N14052.md): Waco UKC · S/N 3927 · Built 1934 · Hogan Thomas A
- [N1728J](https://openairdocs.org/aircraft/N1728J.md): Piper PA-28-140 · S/N 28-24140 · Hogan Thomas A
- [N1768Q](https://openairdocs.org/aircraft/N1768Q.md): Cessna 150L · S/N 15073068 · Built 1971 · Harper John T
- [N2059E](https://openairdocs.org/aircraft/N2059E.md): Cessna 172N · S/N 17271137 · Built 1978 · H & H Aviation Enterprises LLC
- [N220JA](https://openairdocs.org/aircraft/N220JA.md): Cessna 172P · S/N 172-76157 · Built 1984 · Hogan Field Hangars LLC
- [N24832](https://openairdocs.org/aircraft/N24832.md): Miller WM-2 · S/N 002 · Built 1972 · Morris Timothy J
- [N25SK](https://openairdocs.org/aircraft/N25SK.md): Cessna 172N · S/N 17273152 · Built 1979 · H & H Aviation Enteprises LLC
- [N2819Z](https://openairdocs.org/aircraft/N2819Z.md): Bellanca 7ECA · S/N 1236-78 · Hogan Thomas A
- [N2951K](https://openairdocs.org/aircraft/N2951K.md): Luscombe 8E · S/N 5678 · Jacobs John Henry
- [N299A](https://openairdocs.org/aircraft/N299A.md): Cessna 320B · S/N 320B-0057 · Built 1964 · Overman Robert W
- [N3080B](https://openairdocs.org/aircraft/N3080B.md): Beech F33A · S/N CE-1096 · Built 1986 · Lamermayer Amy E
- [N30AV](https://openairdocs.org/aircraft/N30AV.md): Cessna 550 · S/N 550-0026 · Extraordinaire Aviation LLC
- [N31116](https://openairdocs.org/aircraft/N31116.md): Waco UPF-7 · S/N 5735 · Hogan Thomas A
- [N32472](https://openairdocs.org/aircraft/N32472.md): Waco UPF-7 · S/N 5782 · Built 1947 · Hogan Thomas A
- [N325K](https://openairdocs.org/aircraft/N325K.md): Wright Jesse M KIS · S/N 102 · Built 2009 · Morris Timothy J
- [N3340B](https://openairdocs.org/aircraft/N3340B.md): Piper PA-22-135 · S/N 22-2155 · Hao Hangar Rats LLC
- [N34783](https://openairdocs.org/aircraft/N34783.md): Culver LFA · S/N 239 · Built 1941 · M3x Hangar Rats LLC
- [N39700](https://openairdocs.org/aircraft/N39700.md): Waco UPF-7 · S/N 5832 · Built 1942 · Hogan Thomas A
- [N411JV](https://openairdocs.org/aircraft/N411JV.md): Gregory P Bricking BEARHAWK · S/N 411 · Hogan Thomas A
- [N41705](https://openairdocs.org/aircraft/N41705.md): Culver LFA · S/N 398 · Built 1942 · Mx3 Hangar Rats LLC
- [N4315T](https://openairdocs.org/aircraft/N4315T.md): Piper PA-32-260 · S/N 32-7200016 · Built 1971 · Community Health Alliance
- [N45AG](https://openairdocs.org/aircraft/N45AG.md): Cessna 172P · S/N 17275652 · Hogan Thomas A
- [N492MV](https://openairdocs.org/aircraft/N492MV.md): Morris Timothy J AVID FLYER · S/N 1492D · Built 1996 · Morris Timothy J
- [N5118](https://openairdocs.org/aircraft/N5118.md): Waco GXE · S/N 1219 · Hogan Thomas A
- [N6252D](https://openairdocs.org/aircraft/N6252D.md): Cessna 172N · S/N 17272667 · Built 1979 · H & H Aviation Enterprises LLC
- [N6337H](https://openairdocs.org/aircraft/N6337H.md): Piper J3C-65 · S/N 19517 · Built 1946 · Hogan Thomas A
- [N6349J](https://openairdocs.org/aircraft/N6349J.md): Cessna 172N · S/N 17273866 · Built 1980 · H & H Aviation Enterprises LLC
- [N6507](https://openairdocs.org/aircraft/N6507.md): Waco 10 · S/N 1598 · First renewal notice · Hogan Thomas A
- [N670DC](https://openairdocs.org/aircraft/N670DC.md): Beech 35-A33 · S/N CD-343 · Hogan Thomas A
- [N67527](https://openairdocs.org/aircraft/N67527.md): Cessna 152 · S/N 15281892 · Built 1978 · H & H Aviation Enterprises LLC
- [N737AA](https://openairdocs.org/aircraft/N737AA.md): Cessna 172N · S/N 17269258 · Built 1977 · Hogan Thomas A
- [N737KC](https://openairdocs.org/aircraft/N737KC.md): Cessna 172N · S/N 17269468 · Built 1977 · H & H Aviation Enterprises LLC
- [N763E](https://openairdocs.org/aircraft/N763E.md): Waco ASO · S/N A-114 · Built 1929 · Hogan Thomas A
- [N767E](https://openairdocs.org/aircraft/N767E.md): Waco ATO · S/N A-124 · Built 1929 · Hogan Thomas A
- [N823CA](https://openairdocs.org/aircraft/N823CA.md): Learjet 45 · S/N 221 · Extraordinaire Aviation II LLC
- [N8538X](https://openairdocs.org/aircraft/N8538X.md): Waco DSO · S/N 3002 · Hogan Thomas A
- [N93154](https://openairdocs.org/aircraft/N93154.md): Cessna 152 · S/N 15285422 · Built 1981 · H & H Aviation Enterprises LLC
- [N9438A](https://openairdocs.org/aircraft/N9438A.md): Cessna 140A · S/N 15259 · Built 1949 · Corder Charles W

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

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