OpenAirDocs.org
Goshen, NY

Registered aircraft · 35

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 = 'GOSHEN'
  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.

N117BSBalony Kubicek Spol S R O BB-S BLASER · S/N 1917Built 2021 · Blaser SwisslubeN1515TPiper PA-28R-200 · S/N 28R-7235311Built 1972 · Sussman Steven TN2407XBoland Brian J OVERSEAS · S/N 131Built 2002 · Blaser SwisslubeN2416GPadelt PADELT AX7-09 · S/N 403Built 2003 · Blaser Swisslube IncN25051Padelt Albert F P77-06 · S/N 12120Built 2000 · Blaser Swisslube IncN29BPCirrus Design SR22 · S/N 4699Built 2018 · 29 Bp LLCN349Cassidy Ronald 1284D · S/N 101First renewal noticeBuilt 2008 · Blaser Swisslube IncN383JTCirrus Design SR20 · S/N 1714Built 2006 · Emf Aero Leasing LLCN390KAAdvance AX6 65000CVFT · S/N 001Blaser SwisslubeN390KBKlein J/Klein C 35000 HOPPER · S/N 002Built 2011 · Blaser SwisslubeN3970BBoland Brian J EXPLOYER · S/N 70Built 1994 · Blaser PeterN4262Piper PA-28-181 · S/N 2843647First renewal noticeBuilt 2006 · Regal Dent IncN44DECirrus Design SF50 · S/N 0117Built 2019 · Aad Aviation LLCN4789XCessna 150G · S/N 15064839First renewal noticeBuilt 1966 · Grald Jonathan AN55842Piper PA-28-140 · S/N 28-7325502Built 1973 · Ansboro James CN5971BBoland Brian J VOYAGER · S/N 71Built 1997 · Blaser Swiss Lube IncN6016Cassidy Ronald 1660 · S/N 101Built 2006 · Blaser Swisslube IncN6186KCessna 150M · S/N 15077577Built 1975 · Sopalsky John JN6206TBoland ADVENTURER · S/N 96Built 1998 · Blaser SwisslubeN6215JBoland EXPEDITION · S/N 95Blaser SwisslubeN6230VPoulin Ronald R L-A · S/N 0005Built 1996 · Blaser Swisslube IncN686BSArbc Inc DBA Lindstrand 105A · S/N 5547Built 2013 · Blaser SwisslubeN6NBBlaser Niklaus NB75 · S/N 1001Built 2010 · Blaser SwisslubeN7011WPiper PA-28-180 · S/N 28-688Built 1962 · Levine Allen D TrusteeN707GGCirrus Design SR22 · S/N 2251Built 2006 · Liberty Flight LLCN7204PPiper PA-24 · S/N 24-2374Built 1960 · Pittner Hans CN775DHPiper PA-32-260 · S/N 32-1154Built 1969 · Wheels Down Aviation LLCN81399Piper J3C-65 · S/N 15316Built 1946 · Meyers Michael CN845KCJames Ansbro VANS RV9A · S/N 91715Built 2024 · Ansbro James CN8759XCessna 182D · S/N 18253159Built 1961 · Grald Jonathan AN8944PPiper PA-24-260 · S/N 24-4400Built 1966 · Pittner Hans CN900TUltramagic B-70 · S/N 70/51Built 2026 · Blaser Swisslube IncN960CBCassidy Ronald 2075 · S/N 101Built 2007 · Blaser Swisslube IncN970CBCassidy Ronald 1666 · S/N 101Built 2005 · Blaser Swisslube IncN9713NCassidy Ron 1250 · S/N 102Built 2002 · Blaser Swisslube Inc
Back to Goshen, NY