OpenAirDocs.org
Geneseo, NY

Registered aircraft · 21

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N1132NFairchild M-62A-3 · S/N FC-27Built 1942 · 1941 Historical Aircraft Group Museum DBAN19KLSchleicher ASW-19B · S/N 19058Ruskauff David JN2389HEngineering & Research 415-C · S/N 3014Built 1946 · 1941 Historical Aircraft Group MuseumN26ANPzl-Mielec AN-2 · S/N 1G22656Built 1987 · Grasshopper Aviation IncN2997Santavasci Jerome RV9A · S/N 90875Built 2005 · Fly Gerald WN3033EAeronca 7AC · S/N 7AC-6619Built 1946 · 1941 Aircraft GroupN34317Meyers OTW-160 · S/N 61Built 1942 · Grasshopper Aviation IncN345ABDouglas DC3C-S1C3G · S/N 13803Built 1943 · 1941 Historical Aircraft Group MuseumN38633Piper J5A · S/N 5-10161941 Historical Aircraft Group Museum DBAN4359LCessna 172G · S/N 17254433Built 1966 · Koschara Nathaniel LN43908Destiny DESTINY 2000 · S/N 3C0413Simoni Michael JN45GCBeech C-45H · S/N AF-469Built 1954 · Ashworth Corp IncN46KMUniversal GLOBE GC-1B · S/N 95Built 1946 · Moses Kenneth JN540GTGrumman American Avn. AA-1B · S/N AA1B-0460Built 1974 · Matthews GuyN582Beech D17S · S/N 6704Built 1944 · 1941 Historical Aircraft Group DBAN618NWaco CSO · S/N 3110Built 1929 · 1941 Historical Aircraft Group DBAN81421Aeronca 7AC · S/N 7AC-40Registration revokedBuilt 1945 · Banker JamesN84804Aeronca 7AC · S/N 7AC-3518Built 1946 · 42077 LLCN90293Macauley Thomas J CUBY L21B-135 · S/N 690Built 1981 · Grasshopper Aviation IncN9104MCessna 182P · S/N 18264677Built 1976 · Rufe PrestonN9652EBellanca 17-30A · S/N 78-30863Built 1977 · Koschara Nathaniel
Back to Geneseo, NY