OpenAirDocs.org
Ronkonkoma, NY

Registered aircraft · 59

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

N1004TRobinson Helicopter R44 II · S/N 13012Built 2010 · I1 Aviation LLCN105HFCessna 172S · S/N 172S8724Heritage Asset Leasing LLCN108HFCessna 172S · S/N 172S9049Built 2002 · Heritage Asset Leasing LLCN11BYPilatus PC-12/47E · S/N 2295Built 2023 · Rj Aviation LLCN124HFCessna 172S · S/N 172S9632Built 2004 · Heritage Asset Leasing LLCN126HFCessna 172S · S/N 172S9053Built 2002 · Heritage Asset Leasing LLCN127HFCessna 172S · S/N 172S9532Built 2003 · Heritage Asset Leasing LLCN129HFCessna 172S · S/N 172S9667Built 2004 · Heritage Asset Leasing LLCN12GAGrumman American Avn. AA-5B · S/N AA5B0635Built 1977 · Ny Flying Tigers LLCN135ECessna 172M · S/N 17266591Built 1975 · Sport Flying USA IncN136HFCessna 172S · S/N 172S9711Built 2004 · Heritage Asset Leasing LLCN145HFCessna 172S · S/N 172S8745Built 2001 · Heritage Asset Leasing LLCN170AVAlexander Rolinski AVENTURA II S17 · S/N AA2AS1701Built 2018 · Sport Flying USA IncN1747FCessna 172H · S/N 17255142Built 1966 · Smith Jason FN174HFCessna 172S · S/N 172S8257Heritage Asset Leasing LLCN210HFCessna 172S · S/N 172S9040Built 2002 · Heritage Asset Leasing LLCN2119ECessna 172R · S/N 17281212Built 2004 · Mid-Island Air Service IncN223HFCessna 172R · S/N 17281112Built 2002 · Heritage Asset Leasing LLCN2438SCessna 172R · S/N 17280875First renewal noticeBuilt 2000 · Mid-Island Air Service IncN312LMBRM Aero S R O BRISTELL LSA · S/N 312/2018Built 2017 · Sport Flying USA IncN32039Waco UPF-7 · S/N 5670Built 1941 · Hedges Aviation IncN3544GCessna 172R · S/N 17281072Mid-Island Air Service IncN3853RPiper PA-28-180 · S/N 28-5844Built 1970 · Dimichele James JrN40079Robinson Helicopter R44 II · S/N 14869Built 2025 · Atlantic Coast Helicopters LtdN444LJCessna 310R · S/N 310R-1294Built 1978 · Dsl Aviation LLCN452AMSIAI Marchetti F.260C · S/N 40-004Built 1983 · Hedges Aviation IncN454PDAirbus Helicopters MBB-BK117 D-3 · S/N 21429Built 2026 · County Of Suffolk Police DepartmentN457WBBombardier BD-100-1A10 · S/N 20665Built 2016 · Regis Funding V LLCN484AVAero Adventure AVENTURA II · S/N AA2A00178Built 2019 · Sport Flying USA IncN49927Boeing A75N1(PT17) · S/N 75-2403Built 1942 · Ziroli NicholasN51059Cessna 150J · S/N 15069736Donadio Gerard JN5312SCessna 172S · S/N 172S9285Built 2002 · Gace Flying ClubN555UPRobinson Helicopter R22 BETA · S/N 2792Built 1998 · Atlantic Coast Helicopter LtdN5666RCessna 172F · S/N 17253300Built 1965 · Sport Flying USA IncN5928ECessna 172N · S/N 17271964Built 1978 · Gace Flying Club IncN6306FCessna 172N · S/N 17273186Baymax Aviation LLCN633BLBRM Aero S R O BRISTELL LSA · S/N 633/2022Built 2022 · Sport Flying USA IncN66RPDehavilland DHC-1B-2 · S/N 183-18045Hedges Aviation IncN686BLBRM Aero S R O BRISTELL LSA · S/N 686/2023Built 2023 · Sport Flying USA IncN71HFCessna 172S · S/N 172S9758Built 2004 · Heritage Asset Leasing LLCN722GBDJI PHANTOM 3 ADVANCED · S/N P76DCL12B27146Witt Kimathi TN722KBDJI PHANTOM 2 · S/N PH645293222Witt KimathiN72669Cessna 182S · S/N 18280496Built 1999 · Mid-Island Air Service IncN72EErcoupe 415-C · S/N 2918Built 1946 · Toronidis JoannisN733RFCessna 172N · S/N 17268484Built 1976 · Baymax Aviation LLCN7AFCessna 172M · S/N 17264850Built 1975 · N7af LLCN8536YRobinson Helicopter R22 ALPHA · S/N 0438Built 1984 · Eastern Flight Services IncN858KDDJI PHANTOM 3 PROFESSION · S/N P76UDK27B200Y7Witt KimathiN85MGulfstream Aerospace GVII-G600 · S/N 73109Built 2023 · Lf Aviation Partners LLCN86EHRobinson Helicopter R22 BETA · S/N 0585Atlantic Coast Helicopters Ltd
Back to Ronkonkoma, NY