# Registered aircraft: Geneseo, NY

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

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

- [N1132N](https://openairdocs.org/aircraft/N1132N.md): Fairchild M-62A-3 · S/N FC-27 · Built 1942 · 1941 Historical Aircraft Group Museum DBA
- [N19KL](https://openairdocs.org/aircraft/N19KL.md): Schleicher ASW-19B · S/N 19058 · Ruskauff David J
- [N2389H](https://openairdocs.org/aircraft/N2389H.md): Engineering & Research 415-C · S/N 3014 · Built 1946 · 1941 Historical Aircraft Group Museum
- [N26AN](https://openairdocs.org/aircraft/N26AN.md): Pzl-Mielec AN-2 · S/N 1G22656 · Built 1987 · Grasshopper Aviation Inc
- [N2997](https://openairdocs.org/aircraft/N2997.md): Santavasci Jerome RV9A · S/N 90875 · Built 2005 · Fly Gerald W
- [N3033E](https://openairdocs.org/aircraft/N3033E.md): Aeronca 7AC · S/N 7AC-6619 · Built 1946 · 1941 Aircraft Group
- [N34317](https://openairdocs.org/aircraft/N34317.md): Meyers OTW-160 · S/N 61 · Built 1942 · Grasshopper Aviation Inc
- [N345AB](https://openairdocs.org/aircraft/N345AB.md): Douglas DC3C-S1C3G · S/N 13803 · Built 1943 · 1941 Historical Aircraft Group Museum
- [N38633](https://openairdocs.org/aircraft/N38633.md): Piper J5A · S/N 5-1016 · 1941 Historical Aircraft Group Museum DBA
- [N4359L](https://openairdocs.org/aircraft/N4359L.md): Cessna 172G · S/N 17254433 · Built 1966 · Koschara Nathaniel L
- [N43908](https://openairdocs.org/aircraft/N43908.md): Destiny DESTINY 2000 · S/N 3C0413 · Simoni Michael J
- [N45GC](https://openairdocs.org/aircraft/N45GC.md): Beech C-45H · S/N AF-469 · Built 1954 · Ashworth Corp Inc
- [N46KM](https://openairdocs.org/aircraft/N46KM.md): Universal GLOBE GC-1B · S/N 95 · Built 1946 · Moses Kenneth J
- [N540GT](https://openairdocs.org/aircraft/N540GT.md): Grumman American Avn. AA-1B · S/N AA1B-0460 · Built 1974 · Matthews Guy
- [N582](https://openairdocs.org/aircraft/N582.md): Beech D17S · S/N 6704 · Built 1944 · 1941 Historical Aircraft Group DBA
- [N618N](https://openairdocs.org/aircraft/N618N.md): Waco CSO · S/N 3110 · Built 1929 · 1941 Historical Aircraft Group DBA
- [N81421](https://openairdocs.org/aircraft/N81421.md): Aeronca 7AC · S/N 7AC-40 · Registration revoked · Built 1945 · Banker James
- [N84804](https://openairdocs.org/aircraft/N84804.md): Aeronca 7AC · S/N 7AC-3518 · Built 1946 · 42077 LLC
- [N90293](https://openairdocs.org/aircraft/N90293.md): Macauley Thomas J CUBY L21B-135 · S/N 690 · Built 1981 · Grasshopper Aviation Inc
- [N9104M](https://openairdocs.org/aircraft/N9104M.md): Cessna 182P · S/N 18264677 · Built 1976 · Rufe Preston
- [N9652E](https://openairdocs.org/aircraft/N9652E.md): Bellanca 17-30A · S/N 78-30863 · Built 1977 · Koschara Nathaniel

## 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 = 'NY' AND g.registrant_city = 'GENESEO'
ORDER BY g.n_number
```

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