# Cancelled registrations: Troy, NY A list on [Troy, NY](https://openairdocs.org/faa-place/NY/Troy.md). Cancelled aircraft registrations in Troy, NY. - [N605MT](https://openairdocs.org/deregistered/N605MT-2022-02-05.md): Sensefly EBEE · S/N EB-03-832 · Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Innovative Mapping Technologies Lllp - [N31633](https://openairdocs.org/deregistered/N31633-2020-04-24.md): Howard DGA-18 · S/N 633 · Cancelled Apr 24, 2020 · Revoked, canceled · Built 1941 · Miller William - [N198E](https://openairdocs.org/deregistered/N198E-2019-09-06.md): Howard DGA-18 · S/N 635 · Cancelled Sep 6, 2019 · Revoked, canceled · Built 1941 · Smith Arthur L - [N83697](https://openairdocs.org/deregistered/N83697-2017-06-15.md): Aeronca 7AC · S/N 7AC-2375 · Cancelled Jun 15, 2017 · Registration expired, pending cancellation · Built 1946 · Parslow Louis E - [N681GA](https://openairdocs.org/deregistered/N681GA-2013-08-15.md): Beck Theodore P SHA-GLASAIR · S/N 681R · Cancelled Aug 15, 2013 · Sale reported, canceled - [N8482U](https://openairdocs.org/deregistered/N8482U-2013-08-13.md): Rensselar Polytechnic Inst RP · S/N SN1 · Cancelled Aug 13, 2013 · Registration expired, pending cancellation · Rensselaer Polytechnic Institute - [N9996Y](https://openairdocs.org/deregistered/N9996Y-2013-03-25.md): Champion AERONCA 7GCB · S/N 193 · Cancelled Mar 25, 2013 · Sale reported, canceled · Built 1964 - [N397RP](https://openairdocs.org/deregistered/N397RP-2003-09-05.md): Rensselaer Polytechnic Inst RP-3 · S/N DASH3 · Cancelled Sep 5, 2003 · Triennial form not returned · Built 1998 · Rensselaer Polytechnic Institute - [N2480J](https://openairdocs.org/deregistered/N2480J-2001-11-02.md): Cessna 150G · S/N 15065580 · Cancelled Nov 2, 2001 · Triennial form not returned · Built 1966 · Berger Calvin M - [N285RP](https://openairdocs.org/deregistered/N285RP-2001-01-20.md): Rensselaer Polytechnic Inst RP-2 · S/N 285 · Cancelled Jan 20, 2001 · Triennial form not returned · Rensselaer Polytechnic Institute - [N63523](https://openairdocs.org/deregistered/N63523-1998-08-18.md): Cessna 150M · S/N 15077370 · Cancelled Aug 18, 1998 · Exported to Canada · Dufort Emile A - [N7804W](https://openairdocs.org/deregistered/N7804W-1993-07-27.md): Piper PA-28-180 · S/N 281795 · Cancelled Jul 27, 1993 · Triennial form not returned · Zimmie Thomas F - [N3079U](https://openairdocs.org/deregistered/N3079U-1976-08-27.md): Cessna 172E · S/N 17250679 · Cancelled Aug 27, 1976 · Built 1964 · Dickinson Leslie J - [N5442Z](https://openairdocs.org/deregistered/N5442Z-1970-10-21.md): Piper PA-22-108 · S/N 22-9218 · Cancelled Oct 21, 1970 · Rensselaer Flying Club Inc - [N97102](https://openairdocs.org/deregistered/N97102-1964-04-28.md): Grumman G-44 · S/N 1356 · Cancelled Apr 28, 1964 · Exported to New Zealand · Stockholm Robert Q - [N71340](https://openairdocs.org/deregistered/N71340-1963-11-12.md): Luscombe 8A · S/N 2767 · Cancelled Nov 12, 1963 · Mcgrath Wm A - [N60028](https://openairdocs.org/deregistered/N60028-1956-02-14.md): Fairchild M-62C · S/N 300HO · Cancelled Feb 14, 1956 · Bray Paul Jrand Lichtfuss Ralph L - [N48209](https://openairdocs.org/deregistered/N48209-1955-11-24.md): Fairchild M-62A · S/N T42-1522 · Cancelled Nov 24, 1955 · Built 1945 · Mcintyre Hugh H - [N46469](https://openairdocs.org/deregistered/N46469-1955-11-22.md): Fairchild M-62A · S/N T43-5247 · Cancelled Nov 22, 1955 · Built 1943 · Flying Amadawn - [N51876](https://openairdocs.org/deregistered/N51876-1955-04-01.md): Fairchild PT-19B · S/N T435202 · Cancelled Apr 1, 1955 · Mcgrath Wm A - [N78174](https://openairdocs.org/deregistered/N78174-1952-01-02.md): Globe GC-1B · S/N 2174 · Cancelled Jan 2, 1952 · Cluett George B 3rd - [N85076](https://openairdocs.org/deregistered/N85076-1951-11-08.md): Aeronca 7AC · S/N 7AC-3806 · Cancelled Nov 8, 1951 · Edward Campbell - [N2382E](https://openairdocs.org/deregistered/N2382E-1951-02-01.md): Aeronca 7AC · S/N 7AC-5961 · Cancelled Feb 1, 1951 · Airports Operators Inc - [N37023](https://openairdocs.org/deregistered/N37023-1948-08-30.md): Luscombe 8A · S/N 1684 · Cancelled Aug 30, 1948 · Built 1941 · Troy Flyers Inc - [N25257](https://openairdocs.org/deregistered/N25257-1948-06-24.md): Luscombe 8A · S/N 1206 · Cancelled Jun 24, 1948 · Airport Operators Of Troy N Y Inc - [N581M](https://openairdocs.org/deregistered/N581M-1948-02-17.md): Moth 60-GM · S/N 82 · Cancelled Feb 17, 1948 · Built 1929 · Berger Joseph - [N17343](https://openairdocs.org/deregistered/N17343-1943-11-13.md): Ryan Aeronautical ST-A · S/N 143 · Cancelled Nov 13, 1943 · Troy Flyers Inc - [N18901](https://openairdocs.org/deregistered/N18901-1941-07-02.md): Ryan Aeronautical ST-A · S/N 179 · Cancelled Jul 2, 1941 · Troy Flyers Inc - [N657M](https://openairdocs.org/deregistered/N657M-1938-07-01.md): Consolidated FLEETSTER 17 GW-1 · S/N 1 · Cancelled Jul 1, 1938 · Troy Air Service Inc ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql 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 = 'TROY' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id ``` This list as a web page: https://openairdocs.org/faa-place/NY/Troy/earlier --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.