# Cancelled registrations: Gilford, NH

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

Cancelled aircraft registrations in Gilford, NH.

- [N714JN](https://openairdocs.org/deregistered/N714JN-2023-03-04.md): Cessna 150M · S/N 15079213 · Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1977 · Anderson Kenneth P
- [N2071N](https://openairdocs.org/deregistered/N2071N-2022-10-01.md): Cessna 140 · S/N 12307 · Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1947 · Lien Ronald N
- [N3296F](https://openairdocs.org/deregistered/N3296F-2021-08-19.md): Mooney M20F · S/N 670389 · Cancelled Aug 19, 2021 · Built 1967 · Dae Aviation Enterprises Corp
- [N221EZ](https://openairdocs.org/deregistered/N221EZ-2019-08-28.md): OLD West Funding SEAREY · S/N ID403C · Cancelled Aug 28, 2019 · Lewis Charles E
- [N1732Z](https://openairdocs.org/deregistered/N1732Z-2019-05-06.md): Cessna 336 · S/N 336-0032 · Cancelled May 6, 2019 · First renewal notice · Built 1963 · Avery Lauris E Jr
- [N4486P](https://openairdocs.org/deregistered/N4486P-2013-08-19.md): Piper PA-23-160 · S/N 23-2008 · Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1962
- [N9321K](https://openairdocs.org/deregistered/N9321K-2013-01-14.md): Stinson 108-2 · S/N 108-2321 · Cancelled Jan 14, 2013 · Sale reported, pending cancellation · Built 1947
- [N119PC](https://openairdocs.org/deregistered/N119PC-2012-05-15.md): American Champion 7GCBC · S/N 1315-2001 · Cancelled May 15, 2012 · Exported to Canada · Built 2001 · New Hampton Land Co Inc
- [N28603](https://openairdocs.org/deregistered/N28603-2012-02-24.md): Grumman American Avn. AA-5B · S/N AA5B0700 · Cancelled Feb 24, 2012 · Exported to Canada · Built 1978 · Shafique Tajammul
- [N1405F](https://openairdocs.org/deregistered/N1405F-2011-01-03.md): Revo LAKE 250 · S/N 50 · Cancelled Jan 3, 2011 · Expired dealer · Built 1987 · Lake Aircraft Inc
- [N8007K](https://openairdocs.org/deregistered/N8007K-2011-01-03.md): Consolidated Aeronautics LAKE LA-4-200 · S/N 1046 · Cancelled Jan 3, 2011 · Expired dealer · Lake Aircraft Inc
- [N406SB](https://openairdocs.org/deregistered/N406SB-2006-08-10.md): Piper PA-38-112 · S/N 38-79A0061 · Cancelled Aug 10, 2006 · Triennial form not returned · Built 1978 · Skybright Inc
- [N64SF](https://openairdocs.org/deregistered/N64SF-2006-04-28.md): Aerofab LAKE 250 · S/N 112 · Cancelled Apr 28, 2006 · Exported to Canada · Built 1991 · Team Lake LLC
- [N6182P](https://openairdocs.org/deregistered/N6182P-1996-10-01.md): Cessna 152 · S/N 15284983 · Cancelled Oct 1, 1996 · Triennial form not returned · Livernois Gregory
- [N85485](https://openairdocs.org/deregistered/N85485-1994-01-18.md): Aerofab LAKE 250 · S/N 110 · Cancelled Jan 18, 1994 · Exported to Panama · Lake Aircraft North Inc
- [N8423J](https://openairdocs.org/deregistered/N8423J-1993-12-08.md): Aerofab LAKE LA-250 · S/N 90 · Cancelled Dec 8, 1993 · Exported to Philippines · Lake Aircraft North Inc
- [N3837S](https://openairdocs.org/deregistered/N3837S-1991-11-13.md): Burkhart Grob Flugzeugbau G109 · S/N 6124 · Cancelled Nov 13, 1991 · Exported to Netherlands · Sears Richard
- [N738WX](https://openairdocs.org/deregistered/N738WX-1986-01-02.md): Cessna 172N · S/N 17270304 · Cancelled Jan 2, 1986 · Nass Walter P Jr
- [N6650R](https://openairdocs.org/deregistered/N6650R-1983-01-10.md): Beech B19 · S/N MB-741 · Cancelled Jan 10, 1983 · Rutherford James O

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

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