OpenAirDocs.org
Ronkonkoma, NY

Cancelled registrations · 62

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'NY' AND d.registrant_city = 'RONKONKOMA'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N320ACLearjet 60 · S/N 233Cancelled Jun 23, 2026 · Sale reported, canceled · Built 2001N41WMCessna 152 · S/N 15285349Cancelled Mar 3, 2020 · Exported to Czech Republic · Built 1981 · Mid Island Air Service IncN48666Cessna 152 · S/N 15283358Cancelled Mar 3, 2020 · Exported to Czech Republic · Built 1979 · Midisland Airservice IncN25528Cessna 152 · S/N 15280719Cancelled Feb 18, 2020 · Exported to Czech Republic · Built 1977 · Mid Island Air Service IncN297SCCzech Sport Aircraft A S SPORTCRUISER · S/N 09SC282Cancelled Aug 10, 2018 · Registration expired, pending cancellation · Built 2009 · Sport Flying USA IncN5798WPiper PA-28-160 · S/N 28-1813Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1964 · Airborne Maintenance IncN9077FRobinson Helicopter R22 · S/N 0269Cancelled Jan 29, 2018 · Registration expired, pending cancellation · Built 1982 · Eastern Flight Services IncN4066GRobinson Helicopter R22 BETA · S/N 1505Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Built 1990 · Atlantic Coast Helicopter LtdN97224Cessna 172P · S/N 17276165Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1984 · Ameriflyers Of New York IncN871CLRobinson Helicopter R22 BETA · S/N 617Cancelled Mar 10, 2017 · Registration expired, pending cancellation · Built 1987 · Atlantic Coast HelicoptersN642HEnstrom F-28C · S/N 394Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1977 · Metro Helicopters IncN8414HRobinson Helicopter R22 · S/N 0355Cancelled Jun 7, 2013 · Registration expired, pending cancellation · Built 1983 · Atlantic Coast HelicopterN151RMRobinson Helicopter R22 · S/N 0343Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1997 · Atlantic Coast Helicopters LtdN4866PPiper PA-23-250 · S/N 27-441Cancelled May 9, 2013 · Sale reported, canceled · Built 1961N152SHCessna 152 · S/N 15282567Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1978 · Mid-County Flyers IncN4629GCessna 402B · S/N 402B1306Cancelled Dec 11, 2012 · Registration expired, pending cancellation · Built 1977 · Islip Airco IncN955GTBell 206L-3 · S/N 51154Cancelled Sep 5, 2012 · Sale reported, canceled · Built 1985N250THHelfrich-Leonard BEDE BD-5B · S/N 1032Cancelled Aug 21, 2012 · Sale reported, canceled · Built 1978N525XLGrumman G-1159 · S/N 135Cancelled Dec 12, 2011 · Sale reported · Built 1973N9742ZCessna U206G · S/N U20606636Cancelled Jul 12, 2011 · Registration expired · Built 1982 · Airborne Maintenance IncN25446Cessna 152 · S/N 15280666Cancelled May 13, 2011 · Exported to Belarus · Built 1977 · Mid Island Air Service IncN414NYCessna 414A · S/N 414A0242Cancelled Sep 22, 2010 · Second triennial mailing, no response · Built 1979 · Islip Airco IncN62371Cessna 172P · S/N 17275262Cancelled Mar 30, 2010 · Exported to Croatia · Built 1981 · Mid Island Air Service IncN259ABCessna 172R · S/N 17280067Cancelled Jul 20, 2009 · Exported to Canada · Built 1997 · Heritage Asset Leasing LLCN18149Cessna 150L · S/N 15073822Cancelled Jul 9, 2009 · Registration revoked · Built 1972 · Chandelle Aviaiton IncN604EVEvektor-Aerotechnik SPORTSTAR · S/N 20060606Cancelled Jan 15, 2008 · Built 2006 · Mid-Island Air Services IncN756PNCessna R182 · S/N R18201125Cancelled May 26, 2006 · Triennial form not returned · Built 1979 · Gace Flying Club IncN734CWCessna 172N · S/N 17268759Cancelled Mar 1, 2006 · Exported to Philippines · Built 1977 · Mancuso Group IncN1072WBeech 95-B55 (T42A) · S/N TC-1544Cancelled Feb 6, 2006 · Triennial form not returned · Built 1973 · Long Island Jet Center IncN694MExtra Flugzeugbau EA300/200 · S/N 05Cancelled Oct 28, 2004 · Exported to United Kingdom · Built 1996 · Mid Island Air Service IncN9749ACessna 170A · S/N 19210Cancelled Jun 8, 2004 · Triennial form not returned · Built 1950 · Mid Island Air Service IncN184RBeech 65-80 · S/N LD-54Cancelled Jul 22, 2002 · Exported to Venezuela · Built 1963 · Mid Island Air Service IncN270TCBeech C90 · S/N LJ858Cancelled Jul 26, 2001 · Deluxe Jets LLCN99063Cessna 172P · S/N 17276398Cancelled Jul 26, 2000 · Triennial form not returned · Ate Of New York IncN186KCRobinson Helicopter R22 BETA · S/N 0595Cancelled Oct 17, 1998 · Triennial form not returned · Atlantic Coast HelicoptersN2084CBeech 95 · S/N TD267Cancelled Jun 4, 1998 · Triennial form not returned · Avia Pro CorpN613BWCessna T210M · S/N 21061972Cancelled Nov 25, 1997 · Triennial form not returned · Eastway Aircraft Services IncN92327Piper PA-28-181 · S/N 2890170Cancelled Mar 16, 1995 · Exported to Germany · Mid Island Air Service IncN9030ZRobinson Helicopter R22 · S/N 0059Cancelled May 14, 1993 · Triennial form not returned · Suffolk Helicopters IncN90751Messerschmitt-Boelkow-Blohm-Gm BO-105C · S/N S155Cancelled May 26, 1992 · Exported to Israel · Rts Helicopter Funding CorpN8555KRobinson Helicopter R22 ALPHA · S/N 0446Cancelled Feb 7, 1992 · Exported to Canada · Suffolk Helicopters IncN54746Piper PA-23-250 · S/N 277554059Cancelled Jan 13, 1992 · Triennial form not returned · Mid Island Air Service IncN4038NRobinson Helicopter R22 BETA · S/N 1621Cancelled Apr 17, 1991 · Exported to Germany · American Helicopter CorporationN9021MRobinson Helicopter R22 · S/N 0021Cancelled Feb 15, 1991 · Suffolk Helicopters IncN6355DCessna 172N · S/N 17272741Cancelled Jan 24, 1983 · Mid Island Air Service IncN2018KLuscombe 8E · S/N 4745Cancelled Nov 10, 1982 · Built 1947 · Heiser John AN9372TPiper PA-38-112 · S/N 38-78A0076Cancelled Feb 25, 1982 · Mid-Island Air Service IncN8897DPiper PA-18A 150 · S/N 18-6371Cancelled Jan 5, 1982 · Boces Vocational Aviation Mechanical FacilityN39584Piper PA-44-180 · S/N 44-7995013Cancelled Dec 1, 1980 · Exported to Australia · Built 1978 · Mid Island Air Service IncN100TEPiper PA-23-250 · S/N 27-7405327Cancelled May 21, 1979 · Exported to Canada · Built 1974 · Mid Island Air Service Inc
Back to Ronkonkoma, NY