# Cancelled registrations: Buffalo, MN

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

Cancelled aircraft registrations in Buffalo, MN.

- [N6547U](https://openairdocs.org/deregistered/N6547U-2022-09-03.md): Mooney M20C · S/N 2330 · Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 1962 · Wenz Walter W
- [N4258B](https://openairdocs.org/deregistered/N4258B-2021-09-24.md): Beech F35 · S/N D-4235 · Cancelled Sep 24, 2021 · Built 1955 · Johnson Raymond W
- [N761TA](https://openairdocs.org/deregistered/N761TA-2020-01-06.md): DJI INSPIRE 1 · S/N W13DCJ13040517 · Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Aarestad James
- [N593UA](https://openairdocs.org/deregistered/N593UA-2019-03-23.md): DJI PHANTOM 2 VISION + · S/N PH645312510 · Cancelled Mar 23, 2019 · Registration expired, pending cancellation · Aarestad James
- [N6290H](https://openairdocs.org/deregistered/N6290H-2019-03-13.md): DJI PHANTOM 3 ADVANCED · S/N P77DCH20011153 · Cancelled Mar 13, 2019 · Registration expired, pending cancellation · Aarestad James
- [N6222M](https://openairdocs.org/deregistered/N6222M-2018-02-21.md): Piper PA-23-250 · S/N 27-7754104 · Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 1977 · West Metro Aviation LLC
- [N5774F](https://openairdocs.org/deregistered/N5774F-2013-08-20.md): Piper PA-28-140 · S/N 28-25079 · Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1968
- [N5290A](https://openairdocs.org/deregistered/N5290A-2013-08-13.md): Cessna 310 · S/N 35490 · Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1957
- [N6632H](https://openairdocs.org/deregistered/N6632H-2013-04-30.md): Piper J3C-65 · S/N 19829 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1946 · M&M Aviation Inc
- [N6742B](https://openairdocs.org/deregistered/N6742B-2012-08-10.md): Piper PA-22-150 · S/N 22-4075 · Cancelled Aug 10, 2012 · Registration pending, canceled · Built 1956
- [N35899](https://openairdocs.org/deregistered/N35899-2012-06-04.md): Piper J4E · S/N 4-1429 · Cancelled Jun 4, 2012 · Registration pending, canceled · Built 1941
- [N3324P](https://openairdocs.org/deregistered/N3324P-2009-05-05.md): Piper PA-23-160 · S/N 23-1275 · Cancelled May 5, 2009 · Exported to Canada · Built 1958 · Buffalo Flyers Inc
- [N67CF](https://openairdocs.org/deregistered/N67CF-2006-05-12.md): Cessna 182K · S/N 18258012 · Cancelled May 12, 2006 · Exported to Mexico · Built 1967
- [N57912](https://openairdocs.org/deregistered/N57912-2000-01-13.md): Ryan Aeronautical ST3KR · S/N 1711 · Cancelled Jan 13, 2000 · Exported to United Kingdom · Evans Thomas
- [N7355Q](https://openairdocs.org/deregistered/N7355Q-1997-10-03.md): Cessna 182P · S/N 18260995 · Cancelled Oct 3, 1997 · Triennial form not returned · Delta Aviation Inc
- [N38329](https://openairdocs.org/deregistered/N38329-1994-07-19.md): Piper PA-38-112 · S/N 3879A1124 · Cancelled Jul 19, 1994 · Triennial form not returned · Marsh Terry
- [N10794](https://openairdocs.org/deregistered/N10794-1982-09-16.md): Cessna 150L · S/N 15075045 · Cancelled Sep 16, 1982 · Administratively canceled · Anderson Carlo
- [N3311Z](https://openairdocs.org/deregistered/N3311Z-1974-01-11.md): Piper PA-22-160 · S/N 22-7243 · Cancelled Jan 11, 1974 · Exported to Canada · Built 1960 · Ready Flying Service Inc
- [N23189](https://openairdocs.org/deregistered/N23189-1971-01-06.md): Piper J3L-65 · S/N 2980 · Cancelled Jan 6, 1971 · Delta Aviation Association
- [N45592](https://openairdocs.org/deregistered/N45592-1965-05-20.md): Luscombe 8A · S/N 2119 · Cancelled May 20, 1965 · Spike Walter
- [N828H](https://openairdocs.org/deregistered/N828H-1940-08-08.md): Moth 60-GM · S/N 1-Q · Cancelled Aug 8, 1940 · Lewis Severyn Avery

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

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