# Cancelled registrations: Hanover, NH

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

Cancelled aircraft registrations in Hanover, NH.

- [N606SC](https://openairdocs.org/deregistered/N606SC-2013-10-28.md): Piper PA-31-310 · S/N 31-88 · Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1967 · White River Flying Service Inc
- [N252ZF](https://openairdocs.org/deregistered/N252ZF-2013-07-02.md): Mooney M20K · S/N 25-1106 · Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Kuzmier Dirk
- [N62189](https://openairdocs.org/deregistered/N62189-1981-02-23.md): Cessna 172E · S/N R172-0080 · Cancelled Feb 23, 1981 · Exported to Panama · US Army Cold Regions Reserch
- [N9781W](https://openairdocs.org/deregistered/N9781W-1977-08-11.md): Piper PA-28-140 · S/N 28-23270 · Cancelled Aug 11, 1977 · Hicks James
- [N2302M](https://openairdocs.org/deregistered/N2302M-1974-07-10.md): Piper PA-12 · S/N 12-1496 · Cancelled Jul 10, 1974 · Built 1946 · Piane John M Jr\Piane Tinette
- [N9DC](https://openairdocs.org/deregistered/N9DC-1974-02-06.md): Piper PA-28-140 · S/N 28-24878 · Cancelled Feb 6, 1974 · Dartmouth Flying Club Inc
- [N2392B](https://openairdocs.org/deregistered/N2392B-1971-07-23.md): Temco GC-1B · S/N 3692 · Cancelled Jul 23, 1971 · Claflin Lester W
- [N7861H](https://openairdocs.org/deregistered/N7861H-1965-10-28.md): Piper PA-12 · S/N 12-762 · Cancelled Oct 28, 1965 · Exported to Canada · Dartsmouth Flying Club
- [N7554H](https://openairdocs.org/deregistered/N7554H-1962-04-10.md): Piper PA-12 · S/N 12-421 · Cancelled Apr 10, 1962 · Dartmouth Flying Club
- [N8244C](https://openairdocs.org/deregistered/N8244C-1959-04-14.md): Piper PA-22-135 · S/N 22-2330 · Cancelled Apr 14, 1959 · Exported to Canada · Miller R E
- [N60625](https://openairdocs.org/deregistered/N60625-1956-02-15.md): Fairchild M-62C · S/N FE88 · Cancelled Feb 15, 1956 · Dartmouth Airways Inc
- [N52602](https://openairdocs.org/deregistered/N52602-1955-11-21.md): Cessna T-50 · S/N 4442 · Cancelled Nov 21, 1955 · Dartmouth Airways Inc
- [N2484H](https://openairdocs.org/deregistered/N2484H-1955-09-23.md): Engineering & Research ERCOUPE 415-C · S/N 3109 · Cancelled Sep 23, 1955 · Built 1946 · Dartmouth Airways Inc
- [N2059E](https://openairdocs.org/deregistered/N2059E-1952-02-19.md): Aeronca 7AC · S/N 7AC-5629 · Cancelled Feb 19, 1952 · Dartmouth Airways Inc
- [N1465E](https://openairdocs.org/deregistered/N1465E-1951-01-12.md): Aeronca 7AC · S/N 7AC-5028 · Cancelled Jan 12, 1951 · Built 1946 · Hutton James M / Leske Robert R Jr
- [N89743](https://openairdocs.org/deregistered/N89743-1949-05-25.md): Cessna 140 · S/N 8792 · Cancelled May 25, 1949 · Leske Robert R Jr
- [N504](https://openairdocs.org/deregistered/N504-1948-03-31.md): Cessna T-50 · S/N 4449 · Cancelled Mar 31, 1948 · Dartmouth 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 = 'NH' AND d.registrant_city = 'HANOVER'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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