# Cancelled registrations: Kingston, NY

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

Cancelled aircraft registrations in Kingston, NY.

- [N33582](https://openairdocs.org/deregistered/N33582-2023-01-25.md): Piper J3C-65 · S/N 14059 · Cancelled Jan 25, 2023 · Revoked, canceled · Built 1945 · Fox David Rusty
- [N695BP](https://openairdocs.org/deregistered/N695BP-2022-10-01.md): DJI INSPIRE 1 PRO · S/N W21ACL25020176 · Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Ulster County Sheriffs Office
- [N74106](https://openairdocs.org/deregistered/N74106-2013-05-08.md): Strat M-21 · S/N 101 · Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1947 · Fox David R
- [N5254S](https://openairdocs.org/deregistered/N5254S-2012-08-14.md): Piper PA-32-300 · S/N 32-40945 · Cancelled Aug 14, 2012 · Revoked, canceled · Built 1970 · Whittaker Rodney R DBA
- [N5HU](https://openairdocs.org/deregistered/N5HU-2006-07-07.md): Cessna P337H · S/N P3370323 · Cancelled Jul 7, 2006 · Triennial form not returned · Built 1978 · River Aviation Inc
- [N3069E](https://openairdocs.org/deregistered/N3069E-2005-03-10.md): Aeronca S7CCM · S/N 7AC-6658 · Cancelled Mar 10, 2005 · Built 1946 · Morrow John R
- [N2042M](https://openairdocs.org/deregistered/N2042M-1999-06-30.md): Phillips Robert T FLYBABY 1A · S/N 613 · Cancelled Jun 30, 1999 · Triennial form not returned · Phillips Robert T
- [N91036](https://openairdocs.org/deregistered/N91036-1991-03-26.md): Cessna 207 · S/N 20700026 · Cancelled Mar 26, 1991 · Triennial form not returned · Carroll Air Service Inc
- [N30018](https://openairdocs.org/deregistered/N30018-1978-05-18.md): Cessna 177 · S/N 17701026 · Cancelled May 18, 1978 · Built 1968 · Myers Edwin H
- [N1603Q](https://openairdocs.org/deregistered/N1603Q-1976-08-20.md): Cessna 150L · S/N 15072903 · Cancelled Aug 20, 1976 · Exported to Canada · Carroll Air Service
- [N3040Q](https://openairdocs.org/deregistered/N3040Q-1974-07-11.md): Cessna 182K · S/N 18258040 · Cancelled Jul 11, 1974 · Carroll Air Service Inc
- [N1994N](https://openairdocs.org/deregistered/N1994N-1971-08-02.md): Cessna 140 · S/N 12230 · Cancelled Aug 2, 1971 · Weber Robert E
- [N1529U](https://openairdocs.org/deregistered/N1529U-1970-06-19.md): Cessna 207 · S/N 20700129 · Cancelled Jun 19, 1970 · Built 1969 · Carroll Air Service Inc
- [N4822X](https://openairdocs.org/deregistered/N4822X-1967-08-24.md): Cessna 150G · S/N 15064872 · Cancelled Aug 24, 1967 · Exported to Iceland · Carroll Air Svc Inc
- [N9262H](https://openairdocs.org/deregistered/N9262H-1950-11-10.md): Fairchild M-62A-3 · S/N FT-770 · Cancelled Nov 10, 1950 · Mid-Hudson Flying Service Inc
- [N17011](https://openairdocs.org/deregistered/N17011-1947-01-30.md): Commonwealth REARWIN 8500 DELUXE · S/N 527 · Cancelled Jan 30, 1947 · Caunitz Walter H
- [N8163](https://openairdocs.org/deregistered/N8163-1939-02-01.md): Swallow TP · S/N 191 · Cancelled Feb 1, 1939 · Swanson A Paul
- [N1546](https://openairdocs.org/deregistered/N1546-1934-06-29.md): Waco 10 · S/N 901 · Cancelled Jun 29, 1934 · Dealmo Edward
- [N867Y](https://openairdocs.org/deregistered/N867Y-1932-12-12.md): Friedrich H / Kohl A LAND MONOPLANE · S/N 1 · Cancelled Dec 12, 1932 · Friedrich Herman C & Kohl Chas A
- [N2411](https://openairdocs.org/deregistered/N2411-undated.md): National Airways System AIR KING · S/N 27-A · Cancellation date not recorded · Catskill Mountain Airways 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 = 'KINGSTON'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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