# Cancelled registrations: Northfield, MN

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

Cancelled aircraft registrations in Northfield, MN.

- [N5516P](https://openairdocs.org/deregistered/N5516P-2022-11-05.md): Quicksilver GT 500 · S/N GT 500 0067 · Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Built 1991 · Collins Tim
- [N33425](https://openairdocs.org/deregistered/N33425-2021-12-04.md): Piper PA-28-180 · S/N 28-7505144 · Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1975 · Coleman Timothy J
- [N1066D](https://openairdocs.org/deregistered/N1066D-2021-01-09.md): Quicksilver MX II Sprint MXII SPRINT · S/N 0619 · Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1991 · Collins Andrew M
- [N8724X](https://openairdocs.org/deregistered/N8724X-2020-05-29.md): Cessna 182D · S/N 18253124 · Cancelled May 29, 2020 · Registration expired, pending cancellation · Built 1960 · Wirtzfeld Thomas F
- [N396BK](https://openairdocs.org/deregistered/N396BK-2018-01-19.md): Bordelon Bruce KITFOX IV · S/N C94100070 · Cancelled Jan 19, 2018 · Registration expired, pending cancellation · Built 2003 · Svien Benny H
- [N603N](https://openairdocs.org/deregistered/N603N-2017-10-20.md): Waco ASO · S/N 3041 · Cancelled Oct 20, 2017 · Registration expired, pending cancellation · Howell Michael E
- [N83028](https://openairdocs.org/deregistered/N83028-2017-01-24.md): Aeronca 7AC · S/N 7AC1684 · Cancelled Jan 24, 2017 · Revoked, pending cancellation · Built 1946 · Joslyn William B
- [N89KL](https://openairdocs.org/deregistered/N89KL-2013-10-28.md): Guderian Barton FORDSTAR · S/N 007 · Cancelled Oct 28, 2013 · Exported to Canada · Built 1995 · Guderian Barton D
- [N4670E](https://openairdocs.org/deregistered/N4670E-2013-03-18.md): Aeronca 7EC · S/N 7EC-18 · Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1950 · Colton John D
- [N207TW](https://openairdocs.org/deregistered/N207TW-2007-10-22.md): Wakely Terrence J DR-107 · S/N 95-0343 · Cancelled Oct 22, 2007 · Triennial form not returned · Built 1998 · Wakely Terrence J
- [N1345](https://openairdocs.org/deregistered/N1345-2004-03-17.md): Oldfield Baby Great Lakes OBGL-1 · S/N 662-B-33-B · Cancelled Mar 17, 2004 · Triennial form not returned · Built 1970 · Thompson Neale C
- [N4543F](https://openairdocs.org/deregistered/N4543F-2000-05-11.md): Air Tractor AT-401 · S/N 401-0787 · Cancelled May 11, 2000 · Carlsons Ag Aviation Inc
- [N904G](https://openairdocs.org/deregistered/N904G-1998-01-10.md): Gambucci Joseph JR PROTECH PT2 · S/N PT1078 · Cancelled Jan 10, 1998 · Triennial form not returned · Gambucci Joseph Jr
- [N83028](https://openairdocs.org/deregistered/N83028-1970-09-25.md): Aeronca 7AC · S/N AC1684 · Cancelled Sep 25, 1970 · Exported to Canada · Joslyn William B
- [N1840](https://openairdocs.org/deregistered/N1840-1970-09-18.md): Schjeldahl POWERED AIRSHIP · S/N LF00020 · Cancelled Sep 18, 1970 · U S Goverment
- [N2712A](https://openairdocs.org/deregistered/N2712A-1962-03-05.md): Piccard Donald L PICCARD BALLOON P-6 · S/N P-5 · Cancelled Mar 5, 1962 · Piccard Donald L

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

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