OpenAirDocs.org
Farmingdale, NY

Cancelled registrations · 94

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

N55NYGates Learjet 55 · S/N 020Cancelled Nov 4, 2024 · Exported to Mexico · Built 1981 · Year And Lear LLCN97371Universal Stinson 108 · S/N 108-371Cancelled Apr 29, 2023 · Registration expired, pending cancellation · Built 1946 · Sohl Virginia MN52900North American SNJ-2 · S/N 2010Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1943 · Snj-2 CorpN132KTDiamond Aircraft Ind DA20-C1 · S/N C0151Cancelled Oct 18, 2021 · Exported to Canada · Built 2001 · Heavy Metal Air LLCN2293EAeronca 7AC · S/N 7AC5867Cancelled Sep 18, 2020 · Revoked, canceled · Built 1946 · Mostupanick Elizabeth MN239TACostruzioni Aeronautiche Tecna P92 EAGLET · S/N 1429Cancelled Jul 22, 2020 · Sale reported, canceledN648RBYuneec International Q500 4K TYPHOON · S/N YU15212156B04B01Cancelled May 6, 2019 · Registration expired, pending cancellation · Brent Associates IncN127WDSwearingen SA226-T(B) · S/N T-297Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1978 · Ponderosa Air LLCN62382North American SNJ-2 · S/N 2039Cancelled Jan 17, 2019 · First renewal notice · Built 1942 · Snj-2 CorpN294MECessna 172S · S/N 172S8552Cancelled Jan 16, 2019 · Registration expired, pending cancellation · Built 2000 · Hickory Lane CorpN429JMPiper PA-28-151 · S/N 28-7715055Cancelled Jun 27, 2018 · Third renewal notice · Built 1976 · Western Suffolk BocesN224PSFouga CM 170 MAGISTER · S/N 224Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Aeronautical Heritage MuseumN326DMFouga CM 170 MAGISTER · S/N 336Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Aeronautical Heritage MuseumN2156WBeech B19 · S/N MB-671Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1974 · Tefc IncN9782RBeech M35 · S/N D-6283Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 1960 · D&K Aviation IncN25ECLearjet 25 · S/N 25-026Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1969 · Millennium Aircraft Holdings LtdN8422GPiper PA-28-161 · S/N 28-8116291Cancelled Nov 28, 2017 · First renewal notice · Built 1981 · Western Suffolk BocesN93991Engineering & Research 415-C · S/N 1314Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Gorton Carl Co OwN68VYCirrus Design SR20 · S/N 2346Cancelled Aug 22, 2017 · Built 2017 · N68vy LLCN491CDCirrus Design SR20 · S/N 1561Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 2005 · N491cd LtdN8960RChampion AERONCA 7JC · S/N 7JC4Cancelled Feb 2, 2017 · Revoked, pending cancellation · Built 1960 · Harrigan Acft IncN101AVPiper PA-28-161 · S/N 28-7716318Cancelled Aug 9, 2016 · Third renewal notice · Built 1977 · Aircraft R US IncN30283Cessna 162 · S/N 16200094Cancelled Apr 29, 2016 · First renewal notice · Built 2011 · Smc Aviation IncN63676Cessna 150M · S/N 15077476Cancelled Oct 27, 2015 · Built 1975 · Research Foundation Of State University Of NyN381CVSikorsky S-76C · S/N 760453Cancelled May 22, 2015 · Exported to Canada · Built 1996 · Csc Transport III IncN1076PPiper PA-23 · S/N 23-84Cancelled Feb 2, 2015 · Sale reported · Built 1954N4045SBalloon Works FIREFLY 7 · S/N 7888Cancelled Oct 6, 2014 · Registration expired, pending cancellation · Built 1979 · Caccavale MichaelN25728Balloon Works FIREFLY 8B-15 · S/N F8B-447Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1993 · Caccavale MichaelN2553XRobinson Helicopter R22 BETA · S/N 0613Cancelled Jul 8, 2013 · Registration expired, pending cancellation · Coast Line Airways IncN3708GCessna T310R · S/N 310R0902Cancelled Nov 8, 2012 · Registration expired, pending cancellation · Built 1977 · Cosmopolitan Aviation CorpN711EXPiper PA-31-350 · S/N 31-7952075Cancelled Sep 21, 2012 · Registration expired, pending cancellation · Built 1979 · Don Thurber Enterprises IncN50295Cessna 150H · S/N 15069204Cancelled Sep 6, 2012 · Sale reported, pending cancellation · Built 1968N205ATAviation Technologies MCDONL DGLS ATL-A4-L · S/N ATL-148573Cancelled Mar 19, 2010 · Registration pendingN52033North American SNJ-2 · S/N 2040Cancelled Feb 18, 2009 · Built 1946 · Snj-2 CorpN409MRAerospatiale AS355F2 ECUREUIL · S/N 5456Cancelled Mar 21, 2008 · Exported to Dominican Republic · Built 1990 · Partner Aviation LLCN89910Cessna 152 · S/N 15282912Cancelled Nov 15, 2007 · Exported to Poland · Built 1978 · Nassau Flyers IncN7818TYak 18T · S/N 01-32Cancelled Oct 19, 2005 · Exported to Hungary · Built 1993 · Poko Airways LtdN101ECDiamond Aircraft Ind DA20-A1 · S/N 10136Cancelled Aug 26, 2004 · Exported to Germany · Built 1996 · State University Of New York At FarmingdaleN731DADiamond Aircraft Ind DA20-A1 · S/N 10331Cancelled Aug 26, 2004 · Exported to Germany · Built 1998 · State University Of New York At FarmingdaleN327DADiamond Aircraft Ind DA20-A1 · S/N 10327Cancelled Jun 18, 2004 · Exported to Germany · Built 1998 · State University Of New York At FarmingdaleN330DADiamond Aircraft Ind DA20-A1 · S/N 10330Cancelled Jun 18, 2004 · Exported to Germany · Built 1998 · State University Of New York At FarmingdaleN604DADiamond Aircraft Ind DA20-A1 · S/N 10304Cancelled Jun 18, 2004 · Exported to Germany · Built 1997 · State University Of New York At FarmingdaleN628DADiamond Aircraft Ind DA20-A1 · S/N 10328Cancelled Jun 18, 2004 · Exported to Germany · Built 1998 · State University Of New York At FarmingdaleN2009ZBeech C23 · S/N M-2065Cancelled Apr 15, 2002 · Second triennial mailing, no response · Built 1978 · Lincoln Aviation CorporationN60045Beech C23 · S/N M-2125Cancelled Apr 15, 2002 · Second triennial mailing, no response · Built 1978 · Lincoln Aviation CorporationN350SLEurocopter AS 350 BA · S/N 2782Cancelled Jan 20, 2001 · Triennial form not returned · Executive Acft And Heli Holdings LtdN717AVPiper PA-28-161 · S/N 28-7716257Cancelled Jan 11, 2001 · Triennial form not returned · Aircraft Rentals IncN16EJBritish Aerospace BAE JETSTREAM 3101 · S/N 834Cancelled Nov 17, 2000 · Millennium Jetstream Holdings IncN8256RPiper PA-28-161 · S/N 288116017Cancelled Aug 21, 1997 · Triennial form not returned · Nassau Flyers IncN9953TPiper PA-38-112 · S/N 3878A0259Cancelled Jul 17, 1997 · Triennial form not returned · Flightways Of Lng Island Inc
Back to Farmingdale, NY