# Cancelled registrations: Watertown, NY

A list on [Watertown, NY](https://openairdocs.org/faa-place/NY/Watertown.md).

Cancelled aircraft registrations in Watertown, NY.

- [N245](https://openairdocs.org/deregistered/N245-2019-12-05.md): Cessna T337G · S/N P3370219 · Cancelled Dec 5, 2019 · Exported to Canada · Built 1975 · Walter A Minaert Mdpc
- [N28P](https://openairdocs.org/deregistered/N28P-2019-04-29.md): Prentiss Gregory T SR GLASAIR III · S/N 3249 · Cancelled Apr 29, 2019 · Exported to Canada · Built 1999 · Chan Chui S
- [N23939](https://openairdocs.org/deregistered/N23939-2018-03-23.md): Aeronca 65-LA · S/N L5989 · Cancelled Mar 23, 2018 · Revoked, canceled · Built 1939 · Massey G Donald
- [N5813L](https://openairdocs.org/deregistered/N5813L-2018-02-16.md): American AA-5 · S/N AA5-0013 · Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1971 · Davis James N
- [N9501Y](https://openairdocs.org/deregistered/N9501Y-2018-02-16.md): Airframes Unlimited BIG DAWG · S/N TLG0206 · Cancelled Feb 16, 2018 · Third renewal notice · Built 2006 · Warner James A
- [N8426J](https://openairdocs.org/deregistered/N8426J-2013-10-31.md): Cessna 150G · S/N 15066326 · Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1967 · Richland Solo Club
- [N9680K](https://openairdocs.org/deregistered/N9680K-2013-09-17.md): Universal Stinson 108-2 · S/N 108-2680 · Cancelled Sep 17, 2013 · Registration expired, pending cancellation · Built 1947 · Graham Bernard C
- [N64282](https://openairdocs.org/deregistered/N64282-2013-04-29.md): Boland MAY DAY · S/N 4 · Cancelled Apr 29, 2013 · Registration expired, pending cancellation · Built 1975 · Barbour Leslie H
- [N5555U](https://openairdocs.org/deregistered/N5555U-2013-04-01.md): Mierek Steven S QUICKSILVER MX II · S/N 1853 · Cancelled Apr 1, 2013 · Sale reported, canceled
- [N6778H](https://openairdocs.org/deregistered/N6778H-2012-10-31.md): Cessna 172M · S/N 17265578 · Cancelled Oct 31, 2012 · Triennial form not returned · Built 1975 · Rowe Gary E
- [N122DG](https://openairdocs.org/deregistered/N122DG-2008-05-19.md): Willess James A CGS HAWK · S/N HSSC-907-HKS-TRI · Cancelled May 19, 2008 · Triennial form not returned · Built 2003 · Graham Damien
- [N39366](https://openairdocs.org/deregistered/N39366-2007-01-23.md): Aeronca 65-TAF · S/N F4202TA · Cancelled Jan 23, 2007 · Triennial form not returned · Mcwayne Frederick A
- [N5452Y](https://openairdocs.org/deregistered/N5452Y-2004-09-29.md): Cessna T210N · S/N 21064210 · Cancelled Sep 29, 2004 · Exported to Australia · Built 1980 · Mccabes Supply Inc
- [N8184](https://openairdocs.org/deregistered/N8184-2001-05-14.md): Bensen B-8 · S/N T0053882 · Cancelled May 14, 2001 · Davis Jeffrey D
- [N2143W](https://openairdocs.org/deregistered/N2143W-1998-11-06.md): Beech C23 · S/N M-1517 · Cancelled Nov 6, 1998 · Second triennial mailing, no response · Built 1974 · Oconnor Donald L
- [N9024F](https://openairdocs.org/deregistered/N9024F-1991-04-09.md): Hughes 369HE · S/N 1190215E · Cancelled Apr 9, 1991 · Exported to Canada · North Country Helicopter Inc
- [N4294R](https://openairdocs.org/deregistered/N4294R-1980-07-03.md): Piper PA-32-300 · S/N 32-40672 · Cancelled Jul 3, 1980 · Exported to Canada · Built 1969 · Smoothaire Inc
- [N9953R](https://openairdocs.org/deregistered/N9953R-1976-05-28.md): Beech B95 · S/N TD-384 · Cancelled May 28, 1976 · Dunaway-Morgan Co Inc
- [N7957L](https://openairdocs.org/deregistered/N7957L-1974-10-29.md): Beech A23-24 · S/N MA-138 · Cancelled Oct 29, 1974 · Exported to Canada · Parkview Auto Sales Inc
- [N30927](https://openairdocs.org/deregistered/N30927-1965-05-24.md): Piper J3C-65 · S/N 5207 · Cancelled May 24, 1965 · Benson Flying Service Inc
- [N63Q](https://openairdocs.org/deregistered/N63Q-1965-05-18.md): Cessna 140A · S/N 15677 · Cancelled May 18, 1965 · Parr Dorothy Y
- [N87899](https://openairdocs.org/deregistered/N87899-1963-08-01.md): Piper J3C-65 · S/N 15517 · Cancelled Aug 1, 1963 · Exported to Canada · Dumas Roy E
- [N80872](https://openairdocs.org/deregistered/N80872-1958-10-10.md): Globe GC-1B · S/N 275 · Cancelled Oct 10, 1958 · Exported to Canada · Crenshaw Thomas T
- [N99358](https://openairdocs.org/deregistered/N99358-1956-04-13.md): Ercoupe 415-C · S/N 1981 · Cancelled Apr 13, 1956 · Exported to Canada · Built 1946 · Crenshaw Thomas T
- [N23405](https://openairdocs.org/deregistered/N23405-1955-03-18.md): Piper J3L-65 · S/N 3133 · Cancelled Mar 18, 1955 · Built 1939 · Watson Floyd
- [N99722](https://openairdocs.org/deregistered/N99722-1950-06-26.md): Erco 415-C · S/N 2345 · Cancelled Jun 26, 1950 · Benson Colgate Flying Service Inc
- [N99655](https://openairdocs.org/deregistered/N99655-1950-06-16.md): Erco 415-C · S/N 2278 · Cancelled Jun 16, 1950 · Colgate Flying Service Inc
- [N33563](https://openairdocs.org/deregistered/N33563-1949-07-25.md): Piper J3C-65 · S/N 14040 · Cancelled Jul 25, 1949 · Northern Air Services Inc
- [N6436K](https://openairdocs.org/deregistered/N6436K-1947-08-12.md): Republic RC-3 · S/N 686 · Cancelled Aug 12, 1947 · Benson Flying Service Inc
- [N15071](https://openairdocs.org/deregistered/N15071-1941-06-01.md): Piper E-2 · S/N 211 · Cancelled Jun 1, 1941 · Ward Walter & Gene W Miller
- [N21008](https://openairdocs.org/deregistered/N21008-1941-06-01.md): Aeronca K · S/N K-315 · Cancelled Jun 1, 1941 · Van Epps George A
- [N12160](https://openairdocs.org/deregistered/N12160-1935-01-01.md): Stinson W · S/N 3052 · Cancelled Jan 1, 1935 · Taylor Airways Inc
- [N8473](https://openairdocs.org/deregistered/N8473-1931-08-04.md): Stinson SM-2AB · S/N 1078 · Cancelled Aug 4, 1931 · Atkinson Walter S

## 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 = 'WATERTOWN'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/NY/Watertown/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.