OpenAirDocs.org
Poughkeepsie, NY

Cancelled registrations · 47

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

N6465UMooney M20C · S/N 2212Cancelled Jun 2, 2025 · Built 1962 · Dutchess Community College FoundationN850RWRichard Wenzlick CHALLENGER II · S/N CH2-0905-2669Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 2012 · Ellery Raymond LN4063LAerostar International RXS-8 · S/N RXS8-3075Cancelled Jan 31, 2020 · Registration expired, pending cancellation · Built 1997 · Blue Sky BalloonsN51483Aerostar International RXS-8 · S/N RXS8-3118Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 2002 · Blue Sky Balloons IncN7137YAerostar International RX 8 · S/N RX8-3232Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1996 · Blue Sky Balloons IncN51994Fairchild M-62A · S/N T423176Cancelled Aug 5, 2019 · Revoked, canceled · Built 1942 · Agnew ErnestN17499Aeronca K · S/N K-18Cancelled Oct 28, 2017 · Revoked, canceled · Neilson Donald AN2598MRocky Mountain Wings ONE · S/N 082602082Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Nack Stanley RN38GPBeech 65-90 · S/N LJ-46Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1965 · Ptach AntonN847MBMaule MX-7-235 · S/N 10038CCancelled May 21, 2015 · Sale reported, canceledN1600BCessna 421 · S/N 421-0092Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1968 · Ptach AntonN14750Fairchild 24 C8C · S/N 2656Cancelled Oct 25, 2013 · Registration expired, pending cancellation · Built 1934 · Foster Donald CN97112Stinson 108-1 · S/N 108-1112Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1946 · Good Theodore WN17724Waco EGC-7 · S/N 4575Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1937 · Wiemer Jeanne FN2664PConsolidated Aeronautics LAKE LA-4-200 · S/N 883Cancelled Jul 18, 2013 · Registration expired, pending cancellation · Built 1978 · Dutchess Charters IncN51529Piper J3C-65 · S/N 10419Cancelled Jul 16, 2013 · Revoked, canceled · Built 1943 · Merritt Roland HN520LABuckeye DREAM MACHINE · S/N 3409Cancelled May 3, 2013 · Registration expired, pending cancellation · Built 2005 · Anderson Louis IN3942BTurner Leslie P-38 LIGHTNING · S/N L-192Cancelled Apr 1, 2013 · Sale reported, canceledN5890MCessna 310P · S/N 310P0190Cancelled Feb 1, 2013 · Sale reported, canceled · Built 1969N1796Spezio Sport DAL 1 · S/N 206Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1970 · Boddy Glendon RN9165Dietz-Rotor Way SCORPION · S/N 156Cancelled Dec 13, 2012 · Revoked, canceled · Built 1969 · Long Charles T JrN4248Cassutt IIIM · S/N 2724Cancelled Nov 7, 2012 · Sale reported, canceledN4209Jungster II RK2 · S/N 682023Cancelled Jun 12, 2012 · Revoked, canceled · Built 1971 · Allen John WN687DFDziminowicz Alexander V DRAGON FLY · S/N 687Cancelled May 2, 2011 · Triennial form not returned · Built 1997 · Dziminowicz Alexander VN3663TBalloon Works FIREFLY 7 · S/N F7059Cancelled Sep 6, 1996 · Triennial form not returned · Schwenker Rudolph CN5291CBeech C35 · S/N D2681Cancelled Oct 14, 1994 · Triennial form not returned · Miller John MN6415GCessna 150K · S/N 15071915Cancelled Nov 16, 1977 · North Atlantic Leasing CorpN97227Stinson 108 · S/N 108-227Cancelled Oct 12, 1976 · Doherty Michael CN987LSBeech S35 · S/N D-7455Cancelled Aug 24, 1971 · Built 1964 · Smiley Lloyd GN8625WPiper PA-28-235 · S/N 28-10140Cancelled Jan 28, 1971 · Lazy Eight IncN82KAeronca 15AC · S/N 15AC-154Cancelled Nov 17, 1969 · Exported to Canada · Gardner Henry PN4601LCessna 172G · S/N 17254596Cancelled Oct 2, 1969 · Harold E VeederN82KPiper J3L · S/N 4916Cancelled Jul 24, 1967 · Built 1940 · Gardner Henry PN2031AStandard J-1 · S/N 1955SCancelled Sep 24, 1963 · Palen James H C JrN45757Luscombe 8A · S/N 2284Cancelled Apr 30, 1956 · Canora JamesN9241HCessna T-50 · S/N 4378Cancelled Mar 5, 1956 · Sardi'S Air Freight Hi Fence FarmN46155Fairchild PT-19A · S/N T43-7288Cancelled Nov 17, 1955 · Vandewater H EdwinN89705Cessna 120 · S/N 8754Cancelled Aug 2, 1951 · Merte HaroldN89125Cessna 140 · S/N 8133Cancelled Apr 12, 1949 · Hobart M Brockway DBA North State Aviation ServiceN239ECommand-Aire 3C-3 · S/N 553Cancelled Sep 15, 1939 · Walker PeterN21431Piper J-3 · S/N 2274Cancelled Aug 25, 1938 · Built 1938 · Slee Burton WN877KStandard J-1 · S/N 7830Cancelled Feb 11, 1933 · Sleight David SN901NStandard J-1 · S/N 7834Cancelled Feb 10, 1933 · Sleight DavidN9936Travel Air S-6000-B · S/N 1088Cancelled Aug 15, 1932 · Lent Airways IncN5420Travel Air Mfg 2000 · S/N 509Cancelled Dec 5, 1930 · Triangle Flying ClubN9928Travel Air Mfg 2000 · S/N 1111Cancelled Sep 9, 1930 · Willig R EN51780Boeing A75N1 · S/N 75-4520Cancellation date not recorded · Built 1943 · Crandall Robert B / Rekow Lloyd A
Back to Poughkeepsie, NY