# Cancelled registrations: Rochester, NH

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

Cancelled aircraft registrations in Rochester, NH.

- [N619SB](https://openairdocs.org/deregistered/N619SB-2022-03-05.md): DJI PHANTOM 3 ADVANCED · S/N P76DCH14A10657 · Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Bickford Susan A
- [N34669](https://openairdocs.org/deregistered/N34669-2021-06-26.md): Stinson 10A · S/N 7969 · Cancelled Jun 26, 2021 · Sale reported, canceled · Built 1941
- [N9553D](https://openairdocs.org/deregistered/N9553D-2021-03-06.md): Piper PA-22-160 · S/N 22-6470 · Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Built 1959 · Schultze Solar S
- [N640CT](https://openairdocs.org/deregistered/N640CT-2019-06-29.md): DJI PHANTOM 3 PROFESSION · S/N P76DCG0 3016239 · Cancelled Jun 29, 2019 · Registration expired, pending cancellation · Lane Garry R
- [N633BS](https://openairdocs.org/deregistered/N633BS-2019-05-02.md): DJI PHANTOM 2 VISION + · S/N PH645492860 · Cancelled May 2, 2019 · Registration expired, pending cancellation · Bickford Susan Ann
- [N2796X](https://openairdocs.org/deregistered/N2796X-2014-12-22.md): Raven Industries RALLY RX7 · S/N RX7-422 · Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Burch Steven L
- [N5093J](https://openairdocs.org/deregistered/N5093J-2014-10-14.md): Cessna 310R · S/N 310R0213 · Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1975 · Wade Robert L
- [N2NH](https://openairdocs.org/deregistered/N2NH-2013-07-30.md): Grumman American Avn. AA-1B · S/N AA1B-0527 · Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1975 · Clough Leland U
- [N7623K](https://openairdocs.org/deregistered/N7623K-2013-06-10.md): Piper PA-20 · S/N 20-441 · Cancelled Jun 10, 2013 · Sale reported, canceled · Built 1950
- [N80699](https://openairdocs.org/deregistered/N80699-2013-02-27.md): Cessna 140 · S/N 14704 · Cancelled Feb 27, 2013 · Sale reported, canceled
- [N46990](https://openairdocs.org/deregistered/N46990-2012-12-11.md): Colby Walter F PHANTOM · S/N 437-84 · Cancelled Dec 11, 2012 · Sale reported, pending cancellation · Built 1984
- [N50JJ](https://openairdocs.org/deregistered/N50JJ-2009-08-10.md): Beech 65-A90 · S/N LJ-290 · Cancelled Aug 10, 2009 · Triennial form not returned · Built 1967 · Skydive Factory Inc
- [N93220](https://openairdocs.org/deregistered/N93220-1995-10-10.md): Let BLANIK L-13 · S/N 173340 · Cancelled Oct 10, 1995 · Williams Harry D III
- [N1196F](https://openairdocs.org/deregistered/N1196F-1993-04-27.md): American General Acft AG5B · S/N 10109 · Cancelled Apr 27, 1993 · Exported to Latvia · Skyhaven Enterprises International
- [N1195Q](https://openairdocs.org/deregistered/N1195Q-1992-08-06.md): American General Acft AG5B · S/N 10097 · Cancelled Aug 6, 1992 · Exported to Netherlands · Skyhaven Enterprises Inc
- [N5415K](https://openairdocs.org/deregistered/N5415K-1981-11-19.md): North American NAVION B · S/N NAV-4-2315-B · Cancelled Nov 19, 1981 · Exported to Canada · Jackson Richard C
- [N6436A](https://openairdocs.org/deregistered/N6436A-1977-12-13.md): Cessna 182 · S/N 33236 · Cancelled Dec 13, 1977 · Irelandgeorge E
- [N1980N](https://openairdocs.org/deregistered/N1980N-1973-05-29.md): Cessna 140 · S/N 12216 · Cancelled May 29, 1973 · Grondin Francis J
- [N6284H](https://openairdocs.org/deregistered/N6284H-1970-12-24.md): Piper J3C-65 · S/N 19460 · Cancelled Dec 24, 1970 · Revoked, pending cancellation · Built 1946 · Turmelle Roland
- [N9809T](https://openairdocs.org/deregistered/N9809T-1970-06-05.md): Cessna 172A · S/N 47609 · Cancelled Jun 5, 1970 · Skyhaven Inc
- [N38224](https://openairdocs.org/deregistered/N38224-1965-06-05.md): Piper J3L-65 · S/N 6876 · Cancelled Jun 5, 1965 · Wotton Donald
- [N89442](https://openairdocs.org/deregistered/N89442-1949-04-14.md): Cessna 140 · S/N 8474 · Cancelled Apr 14, 1949 · Skyhaven Inc
- [N973M](https://openairdocs.org/deregistered/N973M-1932-09-20.md): Marston & Oroway SPORT · S/N 2 · Cancelled Sep 20, 1932 · Built 1931 · Colman Charles D

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

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