# Cancelled registrations: Lake Elmo, MN

A list on [Lake Elmo, MN](https://openairdocs.org/faa-place/MN/Lake%20Elmo.md).

Cancelled aircraft registrations in Lake Elmo, MN.

- [N42XM](https://openairdocs.org/deregistered/N42XM-2023-12-24.md): Xtremeair XA42 · S/N 136 · Cancelled Dec 24, 2023 · Max Acro Inc
- [N182DS](https://openairdocs.org/deregistered/N182DS-2022-11-21.md): Cessna 182M · S/N 182-59372 · Cancelled Nov 21, 2022 · Registration pending, canceled · Built 1969
- [N320WM](https://openairdocs.org/deregistered/N320WM-2021-01-09.md): Dehavilland DHC-1 CHIPMUNK · S/N E4801/485 · Cancelled Jan 9, 2021 · Registration expired, pending cancellation · Built 1951 · Byers Roger Gene
- [N5692S](https://openairdocs.org/deregistered/N5692S-2020-03-25.md): Beech A23-24 · S/N MA-93 · Cancelled Mar 25, 2020 · Revoked, pending cancellation · Built 1966 · Lake Elmo Aviation Inc
- [N8738M](https://openairdocs.org/deregistered/N8738M-2018-02-21.md): Beech 23 · S/N M-527 · Cancelled Feb 21, 2018 · Registration expired, pending cancellation · Built 1963 · Valters Gatis
- [N5759X](https://openairdocs.org/deregistered/N5759X-2017-03-24.md): Cessna 320 · S/N 320-0059 · Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1961 · Valters Aviation Inc
- [N2608L](https://openairdocs.org/deregistered/N2608L-2015-05-19.md): Piper PA-38-112 · S/N 38-79A0780 · Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1979 · Mayer Aviation Inc
- [N9622](https://openairdocs.org/deregistered/N9622-2013-05-23.md): Miller PIETENPOL AIRCAMPER · S/N 1 · Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1969 · Hahn Jerome E
- [N44069](https://openairdocs.org/deregistered/N44069-2012-06-27.md): Taylorcraft BF · S/N 9869 · Cancelled Jun 27, 2012 · Revoked, canceled · Built 1946 · White Bear Flying Svc
- [N13585](https://openairdocs.org/deregistered/N13585-2009-07-21.md): Cessna 172M · S/N 17262859 · Cancelled Jul 21, 2009 · Triennial form not returned · Built 1973 · Johnson Daryl D
- [N94PT](https://openairdocs.org/deregistered/N94PT-2000-12-04.md): Koktavy James W PROTECH PT2 · S/N 1094 · Cancelled Dec 4, 2000 · Gunderson Marlon O
- [N25687](https://openairdocs.org/deregistered/N25687-1994-06-24.md): Piper PA-38-112 · S/N 3881A0054 · Cancelled Jun 24, 1994 · Triennial form not returned · Mayer Aviation Inc
- [N6560K](https://openairdocs.org/deregistered/N6560K-1986-03-14.md): Grumman G-164B · S/N 369B · Cancelled Mar 14, 1986 · Exported to Canada · Chandler Conrad
- [N24213](https://openairdocs.org/deregistered/N24213-1979-02-07.md): Cessna 152 · S/N 152-80153 · Cancelled Feb 7, 1979 · Exported to Canada · Built 1977 · Elmo Aero Inc
- [N14701](https://openairdocs.org/deregistered/N14701-1976-06-30.md): Bellanca 17-30A · S/N 74-30680 · Cancelled Jun 30, 1976 · Exported to Canada · Ward Holliday Aviation Inc
- [N4769J](https://openairdocs.org/deregistered/N4769J-1975-08-27.md): Beech A23-19 · S/N MB-205 · Cancelled Aug 27, 1975 · Built 1967 · Elmo Aero Inc
- [N9947N](https://openairdocs.org/deregistered/N9947N-1975-07-03.md): Cessna 180 · S/N 18052602 · Cancelled Jul 3, 1975 · Exported to Canada · Elmo Aero Inc
- [N9647L](https://openairdocs.org/deregistered/N9647L-1975-05-09.md): Grumman American Avn. AA-1B · S/N AA1B-0147 · Cancelled May 9, 1975 · Elmo Aero Inc
- [N3JA](https://openairdocs.org/deregistered/N3JA-1975-05-08.md): Bellanca 17-30A · S/N 73-30519 · Cancelled May 8, 1975 · Built 1972 · Elmo Aero Inc
- [N40648](https://openairdocs.org/deregistered/N40648-1975-05-08.md): Maule M-4-220C · S/N 2164C · Cancelled May 8, 1975 · Built 1973 · Elmo Aero Inc
- [N57512](https://openairdocs.org/deregistered/N57512-1975-05-08.md): Bellanca 7ECA · S/N 955-73 · Cancelled May 8, 1975 · Elmo Aero Inc
- [N6542Q](https://openairdocs.org/deregistered/N6542Q-1975-05-08.md): Alon A2 · S/N A-142 · Cancelled May 8, 1975 · Elmo Aero Inc
- [N88271](https://openairdocs.org/deregistered/N88271-1974-10-08.md): Bellanca 7GCBC · S/N 754-74 · Cancelled Oct 8, 1974 · Exported to Canada · Elmo Aero Inc
- [N7219G](https://openairdocs.org/deregistered/N7219G-1974-09-18.md): Cessna 172K · S/N 17258919 · Cancelled Sep 18, 1974 · Exported to Canada · Elmo Aero Inc/ Lake Elmo Airport
- [N2097U](https://openairdocs.org/deregistered/N2097U-1974-05-21.md): Cessna U206F · S/N U20602342 · Cancelled May 21, 1974 · Exported to El Salvador · Built 1974 · Elmo Aero Inc
- [N99599](https://openairdocs.org/deregistered/N99599-1974-05-10.md): Ercoupe 415-C · S/N 2222 · Cancelled May 10, 1974 · Exported to Canada · Built 1946 · Elmo Aero Inc
- [N41679](https://openairdocs.org/deregistered/N41679-1973-11-29.md): Bellanca 7ECA · S/N 975-73 · Cancelled Nov 29, 1973 · Exported to Canada · Elmo Aero Inc
- [N4213X](https://openairdocs.org/deregistered/N4213X-1973-07-31.md): Aero Commander 100-180 · S/N 5213 · Cancelled Jul 31, 1973 · Exported to Canada · Elmo Aero Inc
- [N5553W](https://openairdocs.org/deregistered/N5553W-1973-04-02.md): Piper PA-28-160 · S/N 28-645 · Cancelled Apr 2, 1973 · Exported to Canada · Elmo Aero Inc
- [N1174C](https://openairdocs.org/deregistered/N1174C-1973-02-23.md): Piper PA-22-135 · S/N 22-1000 · Cancelled Feb 23, 1973 · Exported to Canada · Elmo Aero Inc
- [N70163](https://openairdocs.org/deregistered/N70163-1972-11-17.md): Cessna A185E · S/N 18502029 · Cancelled Nov 17, 1972 · Exported to Australia · Elmo Aero Inc
- [N2194Y](https://openairdocs.org/deregistered/N2194Y-1972-02-02.md): Cessna 172D · S/N 17249694 · Cancelled Feb 2, 1972 · Exported to Canada · Elmo Aero Inc
- [N7171G](https://openairdocs.org/deregistered/N7171G-1971-04-21.md): Cessna 172K · S/N 17258871 · Cancelled Apr 21, 1971 · Exported to Canada · Elmo Aero Inc
- [N22581](https://openairdocs.org/deregistered/N22581-1970-08-13.md): Cessna 150H · S/N 15068375 · Cancelled Aug 13, 1970 · Exported to Canada · Elmo Aero Inc
- [N7903V](https://openairdocs.org/deregistered/N7903V-1970-08-07.md): Cessna 180H · S/N 18051803 · Cancelled Aug 7, 1970 · Exported to Canada · Elmo Aero Inc
- [N1128L](https://openairdocs.org/deregistered/N1128L-1970-06-29.md): Lake LA-4 · S/N 290 · Cancelled Jun 29, 1970 · Elmo Aero Inc
- [N98357](https://openairdocs.org/deregistered/N98357-1964-01-13.md): Piper J3C-65 · S/N 18527 · Cancelled Jan 13, 1964 · Exported to Canada · White Bear Flying Service

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

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