OpenAirDocs.org
Penn Yan, NY

Registered aircraft · 36

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 = 'PENN YAN'
  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.

N107RFCessna 172M · S/N 17260862Built 1972 · Stevens Matthew SN117YLinwood Louis Hough SW-51 MUSTANG · S/N 010Hough Linwood LN14373Piper E-2 · S/N 117Middlebrook ReeceN14580Stinson SR-5E · S/N 9318-ABuilt 1934 · Jackson David CN14585Stinson SR-5 · S/N 9322ABuilt 1935 · Jackson DavidN151VTBeech C35 · S/N D-2714Built 1951 · Mitchell Matthew JN1560BLuscombe 8F · S/N 6187Built 1948 · Jackson David ClarkN206HCCessna U206G · S/N U20604356Built 1978 · Hough Linwood LN208GGPiper PA-28-181 · S/N 28-7690073Built 1975 · Penn Yan Flying Club IncN234HUAviat A-1 · S/N 1336Built 1996 · Stevens Matthew SN2576HErcoupe 415-C · S/N 3201Built 1948 · Martin Aaron MN33497Piper J3L-65 · S/N 6029Built 1940 · Cleveland David LN362MMCirrus Design SR20 · S/N 1766Built 2007 · Fly Second Wind LLCN3839KBoeing E75 · S/N 75-8429Built 1943 · Middlebrook Paul EN447SFCessna 550 · S/N 550-1020Built 2002 · Seneca Foods CorpN480HCEnstrom Helicopter 480B · S/N 5112Built 2007 · Hangar Seven LLCN486BHHodge William HODGE SONERAI II · S/N 748Stevens Matthew SN5002TPiper PA-28-180 · S/N 28-7205237Built 1972 · Penn Yan Flying Club IncN58PBeech 58P · S/N TJ-303Built 1980 · Hangar Seven LLCN6008TCessna 150D · S/N 15060708Built 1964 · Youngman Lawrence JN6473HPiper J3C-65 · S/N 19654Built 1946 · Penn Yan Flying Club IncN6546NCessna T210N · S/N 21063102Built 1978 · Mitchell Matthew JN66266Cessna 180K · S/N 18052932Built 1977 · Cleveland Monica LN6728SCessna 150H · S/N 15067528Built 1967 · Stevens Matthew SN714EYCessna 170B · S/N 25668Built 1953 · Stevens Matthew SN714NXCessna 150M · S/N 15079314Built 1977 · Penn Yan Flying Club IncN727PMCessna 172P · S/N 17275485Built 1981 · Middlebrook Paul EN73450Cessna 172M · S/N 17267468Built 1976 · Penn Yan Flying Club IncN76EHPiper PA-32R-300 · S/N 32R-7680034Built 1975 · Mitchell Matthew JN77SFCessna 650 · S/N 650-7072Built 1996 · Seneca Foods CorpN8342YPiper PA-28-181 · S/N 28-8190179Built 1981 · Thompson Kevan RN83715Aeronca 7AC · S/N 7AC-2393Built 1946 · Middlebrook Paul EN8717XCessna 182D · S/N 18253117Built 1960 · Stevens Matthew SN87SFCessna 560 · S/N 560-0616Built 2002 · Seneca Foods CorpN900WMPiper PA-18-150 · S/N 18-5079Built 1956 · Middlebrook WilliamN92ANAviat A-1 · S/N 1220Built 1992 · Stevens Matthew S
Back to Penn Yan, NY