White Plains, NY

Cancelled registrations · 102

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 = 'WHITE PLAINS'
  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.

N780PSikorsky S-76D · S/N 761030Cancelled Jun 13, 2025 · Exported to India · Built 2013 · International Business Machines CorpN151JEIsrael Aircraft Industries GULFSTREAM 200 · S/N 152Cancelled Oct 29, 2021 · Exported to Canada · Built 2006 · Jet Edge Partners LLCN8361YAeryon Labs SKY RANGER · S/N SR9161671Cancelled May 8, 2021 · Registration expired, pending cancellation · Power Authority Of The State Of New YorkN836YNAeryon Labs SKY RANGER · S/N SR2162472Cancelled May 8, 2021 · Registration expired, pending cancellation · Power Authority Of The State Of New YorkN836ZDAeryon Labs SKY RANGER · S/N SR8160627Cancelled May 8, 2021 · Registration expired, pending cancellation · Power Authority Of The State Of New YorkN837DPAeryon Labs SKY RANGER · S/N SR2164656Cancelled May 8, 2021 · Registration expired, pending cancellation · Power Authority Of The State Of New YorkN3636RPiper PA-28-180 · S/N 28-5731Cancelled Sep 11, 2020 · Sale reported, canceled · Built 1970N8777MBeech A23 · S/N M-562Cancelled Sep 6, 2019 · Revoked, canceled · Built 1964 · Byrne Aircraft Sales IncN8124HHiller UH-12 · S/N 124Cancelled Mar 2, 2019 · Revoked, pending cancellation · Built 1949 · Helicopter Utilities IncN587AAMcdonnell Douglas DC-9-82(MD-82) · S/N 53250Cancelled Nov 2, 2018 · Sale reported, canceled · Built 1991N74ZDouglas DC3C 1830-94 · S/N 25953Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1944N802JAWings Aloft SEAREY · S/N 1MK257Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Built 2002 · Wings Aloft LLCN8112HHiller UH-12 · S/N 112Cancelled Apr 6, 2018 · Revoked, canceled · Built 1949 · Helicopter Utilities IncN188DDRobinson Helicopter R44 II · S/N 11314Cancelled Dec 13, 2017 · First renewal notice · Built 2006 · Awesome Flight LLCN28239Socata TAMPICO TB 9C · S/N 1152Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Westchester Aeronautical CorpN8500North American NA-265-40 · S/N 282-108Cancelled Feb 23, 2017 · Built 1972 · Safe Flight Instrument CorpN100HFGulfstream Aerospace G-IV · S/N 1338Cancelled Aug 21, 2013 · Exported to Mexico · Built 1998 · Bank Of America NaN5382RCessna 172F · S/N 17252917Cancelled Apr 2, 2013 · Sale reported, canceled · Built 1965N40293Piper PA-23-250 · S/N 27-7305108Cancelled Mar 7, 2013 · Registration expired, pending cancellation · Built 1973 · Fifty Eight Mayfair CorpN74053Nagler Helicopter NAGLER HELICOPTER · S/N 2Cancelled Jun 30, 2011 · Revoked, pending cancellation · Built 1955 · Nagler Helicopter Co IncN127CCasale STITS SA6-B · S/N P2065Cancelled Jun 19, 2009 · Registration revoked · Built 1970 · Mazza JeanN38DMSchweizer 269C · S/N S1458Cancelled Mar 19, 2009 · Triennial form not returned · Built 1990 · Wings Air LLCN5012SPiper PA-28R-200 · S/N 28R-35739Cancelled Apr 19, 2007 · Triennial form not returned · Built 1970 · Homan William PN500PCCanadair CL-600-2B16 · S/N 5071Cancelled Oct 26, 2005 · Exported to Gabon · Built 1990 · Pepsico IncN697DADiamond Aircraft Ind DA20-A1 · S/N 10219Cancelled Dec 26, 2002 · Exported to Austria · Built 1996 · Westchester Aeronautical CorpN734CDCessna 172N · S/N 17268742Cancelled May 25, 2000 · Exported to Italy · Pasquini GiovanniN8540QCessna TU206F · S/N U20603396Cancelled Jan 6, 1998 · Exported to Ecuador · Texaco Petroleum CoN7GABeech A100 · S/N B119Cancelled Sep 17, 1997 · Triennial form not returned · Westchester Air IncN6155JPiper PA-32-260 · S/N 327600017Cancelled Sep 5, 1997 · Exported to SwedenN374GCanadair CL-600-2A12 · S/N 3015Cancelled Nov 24, 1993 · Exported to Mexico · General Electric CoN58CVBeech 58 · S/N TH1226Cancelled Sep 1, 1992 · Exported to South Africa · El Jen Equipment CorpN552FLPiper PA-28-140 · S/N 287125390Cancelled Aug 13, 1983 · Westchester Aeronautical CorpN277SWZill EXPLORER · S/N 007Cancelled Jul 5, 1983 · Built 1976 · Zill Paul VN632SQCessna 500 · S/N 500-0344Cancelled Mar 25, 1982 · Exported to Switzerland · Stauffer Chemical CoN600CBBeech 100 · S/N B-36Cancelled Jun 16, 1977 · Exported to Canada · Joseph T Barta Associates IncN418LABeech 100 · S/N B-61Cancelled Oct 29, 1976 · Exported to Canada · Built 1970 · Joseph T Barta Associates IncN9PNMitsubishi MU-2B-20 · S/N 222Cancelled Sep 22, 1976 · Exported to Finland · Built 1972 · Joseph T Barta Assoc IncN74KABeech A100 · S/N B-197Cancelled Sep 15, 1976 · Exported to Uganda · Joseph T Barta Assoc IncN79876Cessna 172K · S/N 17258211Cancelled Jun 16, 1976 · Westchester County Police Pilots Association IncN1ANMitsubishi MU-2B-10 · S/N 109Cancelled Jun 4, 1974 · Exported to Canada · Built 1968 · Joseph T Barta Associates IncN622RDassault/Sud MYSTERE FALCON 20 · S/N 86Cancelled Aug 6, 1973 · Exported to United Kingdom · Joseph T Barta Assoc IncN9993RBeech B95 · S/N TD-427Cancelled Jun 27, 1973 · Merritt Paul E IIIN42QFairchild F-27A · S/N 66Cancelled Dec 18, 1972 · Exported to Canada · Union Carbide CorpN7489RPiper PA-28-140 · S/N 28-22043Cancelled Feb 28, 1972 · Westchester Aeronautical CorpN337NHCessna 337D · S/N 3371080Cancelled Mar 3, 1971 · International Aviaiton Industries IncN4194LCessna 172G · S/N 172-54263Cancelled Jan 13, 1971 · International Aviation Ind. IncN239PSwearingen SA-26AT · S/N T26-147Cancelled Jun 29, 1970 · Air Combustion IncN82008Aeronca 7AC · S/N 7AC-633Cancelled Jun 25, 1970 · Westchester Aeronautical CorpN82679Aeronca 7AC · S/N 1321Cancelled Jun 25, 1970 · Westchester Aeronautocal CorpN84625Aeronca 7AC · S/N 7AC-3332Cancelled Jun 25, 1970 · Westchester Aeronautical Corp
Back to White Plains, NY