# Cancelled registrations: Ballston Spa, NY

A list on [Ballston Spa, NY](https://openairdocs.org/faa-place/NY/Ballston%20Spa.md).

Cancelled aircraft registrations in Ballston Spa, NY.

- [N1809C](https://openairdocs.org/deregistered/N1809C-2024-10-07.md): Hummer David S EXPRESS · S/N HD02066E · Cancelled Oct 7, 2024 · Built 2002 · Hummer David S
- [N2648M](https://openairdocs.org/deregistered/N2648M-2022-12-31.md): Earthstar THUNDER GULL J · S/N J1675 · Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 2000 · Gorton Gregory A
- [N894PC](https://openairdocs.org/deregistered/N894PC-2019-09-06.md): DJI Innovations INSPIRE 1 · S/N W13DCK11050759 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Northeast Aerial LLC
- [N7145J](https://openairdocs.org/deregistered/N7145J-2018-04-18.md): Wiederkehr George H NA · S/N GHW-3M · Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Weiderkehr George H
- [N336DN](https://openairdocs.org/deregistered/N336DN-2017-04-18.md): Cessna 208 · S/N 20800001 · Cancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 1985 · North American Flight Services Inc
- [N46523](https://openairdocs.org/deregistered/N46523-2015-05-06.md): Cessna 172K · S/N 17257324 · Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1968 · Gnip Louis J
- [N8547D](https://openairdocs.org/deregistered/N8547D-2013-05-14.md): Piper PA-22-160 · S/N 22-5778 · Cancelled May 14, 2013 · Registration expired, pending cancellation · Built 1957 · Olson Richard S
- [N33729](https://openairdocs.org/deregistered/N33729-2012-10-04.md): Aeronca 65-TC · S/N 9171T · Cancelled Oct 4, 2012 · Registration expired, pending cancellation · Built 1941 · Pritchard Marion G
- [N733BU](https://openairdocs.org/deregistered/N733BU-2011-05-02.md): Cessna 172N · S/N 17268175 · Cancelled May 2, 2011 · Exported to Canada · Built 1976 · Skyhawk Flyers LLC
- [N2632P](https://openairdocs.org/deregistered/N2632P-2009-07-15.md): Piper PA-22-150 · S/N 22-2970 · Cancelled Jul 15, 2009 · Registration revoked · Built 1955 · Fitzgerald Lester J
- [N5018R](https://openairdocs.org/deregistered/N5018R-2002-06-06.md): Cessna 172M · S/N 17263259 · Cancelled Jun 6, 2002 · Exported to Canada · Built 1974 · Saratoga Flyers Inc
- [N71817](https://openairdocs.org/deregistered/N71817-1997-03-14.md): Hayes Clifford G KOLB TWINSTAR · S/N TS281 · Cancelled Mar 14, 1997 · Triennial form not returned · Hayes Clifford G
- [N4VG](https://openairdocs.org/deregistered/N4VG-1994-05-02.md): Beech 58 · S/N TH865 · Cancelled May 2, 1994 · Triennial form not returned · Vader Air Inc
- [N2909K](https://openairdocs.org/deregistered/N2909K-1993-08-27.md): Luscombe 8 · S/N 5636 · Cancelled Aug 27, 1993 · Triennial form not returned · Lanfear G Raymond Jr
- [N26267](https://openairdocs.org/deregistered/N26267-1970-09-16.md): Stinson 10 · S/N 7551 · Cancelled Sep 16, 1970 · Richard C Pillsbury
- [N35858](https://openairdocs.org/deregistered/N35858-1965-05-07.md): Piper J3C-65 · S/N 6626 · Cancelled May 7, 1965 · Built 1941 · Pickney John III

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

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