# Cancelled registrations: Devils Lake, ND

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

Cancelled aircraft registrations in Devils Lake, ND.

- [N34459](https://openairdocs.org/deregistered/N34459-2020-07-17.md): Aeronca 65-LB · S/N L14741 · Cancelled Jul 17, 2020 · Sale reported, canceled
- [N8194T](https://openairdocs.org/deregistered/N8194T-2020-01-06.md): Cessna 175B · S/N 17556894 · Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Schlieve Terry T
- [N5072N](https://openairdocs.org/deregistered/N5072N-2018-04-19.md): Six Chuter SR7 XL · S/N SR7XL-2495 · Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 2000 · Kvelstad Korey R
- [N4650W](https://openairdocs.org/deregistered/N4650W-2018-03-02.md): Weatherly 620A · S/N 1539 · Cancelled Mar 2, 2018 · Registration expired, pending cancellation · Built 1992 · Foss & Meier Flight Service
- [N2031J](https://openairdocs.org/deregistered/N2031J-2017-07-07.md): Cessna T188C · S/N T18803336T · Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1978 · Moore Glen E
- [N75089](https://openairdocs.org/deregistered/N75089-2017-02-04.md): Piper PA-32R-300 · S/N 32R-7680255 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1976 · Buchanan James F
- [N6301R](https://openairdocs.org/deregistered/N6301R-2015-05-15.md): Piper PA-28-140 · S/N 28-21464 · Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1966 · Ness Dan Paul
- [N7444P](https://openairdocs.org/deregistered/N7444P-2015-05-14.md): Piper PA-24-250 · S/N 24-2633 · Cancelled May 14, 2015 · Sale reported, canceled · Built 1961
- [N8603Z](https://openairdocs.org/deregistered/N8603Z-2013-08-29.md): Buckeye Industries EAGLE · S/N 3137 · Cancelled Aug 29, 2013 · Sale reported, canceled · Built 1994
- [N8727L](https://openairdocs.org/deregistered/N8727L-2013-05-20.md): Piper PA-25-260 · S/N 25-5186 · Cancelled May 20, 2013 · Registration expired, pending cancellation · Built 1969 · Dakota Aircraft Service
- [N437S](https://openairdocs.org/deregistered/N437S-2013-01-11.md): North American SNJ-5 · S/N 88-15738 · Cancelled Jan 11, 2013 · Registration pending, pending cancellation · Built 1958
- [N2317P](https://openairdocs.org/deregistered/N2317P-2009-07-13.md): Piper PA-22-150 · S/N 22-2728 · Cancelled Jul 13, 2009 · Registration revoked · Built 1955 · Lake Region Flg Club Inc
- [N4999R](https://openairdocs.org/deregistered/N4999R-2006-02-03.md): Cessna A188B · S/N 18802486T · Cancelled Feb 3, 2006 · Revoked by enforcement action · Built 1975
- [N11024](https://openairdocs.org/deregistered/N11024-1991-03-26.md): Champion 7ECA · S/N 4 · Cancelled Mar 26, 1991 · Triennial form not returned · Baker Jack E
- [N70426](https://openairdocs.org/deregistered/N70426-1991-01-29.md): Cessna A188B · S/N 18801919T · Cancelled Jan 29, 1991 · Triennial form not returned · Wakefield Tom J
- [N5715U](https://openairdocs.org/deregistered/N5715U-1984-11-19.md): Piper PA-28-140 · S/N 28-26515 · Cancelled Nov 19, 1984 · Exported to Canada · Parkin Harold
- [N2172J](https://openairdocs.org/deregistered/N2172J-1982-01-19.md): Cessna A188B · S/N 18803409T · Cancelled Jan 19, 1982 · Built 1979 · Wakefield Daniel L Et Al
- [N72108](https://openairdocs.org/deregistered/N72108-1974-08-30.md): Cessna 140 · S/N 9273 · Cancelled Aug 30, 1974 · Wakefield Thomas
- [N3759R](https://openairdocs.org/deregistered/N3759R-1974-04-11.md): Cessna 172H · S/N 17255559 · Cancelled Apr 11, 1974 · Exported to Canada · Wakefield Daniel L
- [N6187D](https://openairdocs.org/deregistered/N6187D-1973-04-04.md): Piper PA-18A · S/N 18-5476 · Cancelled Apr 4, 1973 · Exported to Canada · Meier Michael
- [N3684P](https://openairdocs.org/deregistered/N3684P-1970-08-05.md): Piper PA-18 · S/N 18-4585 · Cancelled Aug 5, 1970 · Exported to Canada · Ron J Miller
- [N9435B](https://openairdocs.org/deregistered/N9435B-1970-06-25.md): Cessna 175 · S/N 55235 · Cancelled Jun 25, 1970 · Wakefield Daniel L
- [N7787D](https://openairdocs.org/deregistered/N7787D-1970-06-22.md): Piper PA-18 · S/N 18-6779 · Cancelled Jun 22, 1970 · Wakefield Daniel L
- [N79295](https://openairdocs.org/deregistered/N79295-1970-04-17.md): Piper J3C-65 · S/N 13405 · Cancelled Apr 17, 1970 · Exported to Canada · Wakefield Thomas J
- [N1721E](https://openairdocs.org/deregistered/N1721E-1965-10-22.md): Aeronca 7AC · S/N 7AC-5286 · Cancelled Oct 22, 1965 · Larson Glenn H
- [N1082A](https://openairdocs.org/deregistered/N1082A-1965-05-18.md): Piper PA-18-125 · S/N 18-668 · Cancelled May 18, 1965 · Wakefield Flight Service
- [N4374E](https://openairdocs.org/deregistered/N4374E-1961-11-28.md): Aeronca 7DC · S/N 7DC-33 · Cancelled Nov 28, 1961 · Lake Region Flying Service Inc
- [N3364A](https://openairdocs.org/deregistered/N3364A-1961-04-28.md): Piper PA-22-135 · S/N 22-1663 · Cancelled Apr 28, 1961 · Wayne Riggen
- [N86854](https://openairdocs.org/deregistered/N86854-1961-04-19.md): Bellanca 14-13 · S/N 1216 · Cancelled Apr 19, 1961 · Toomey G W
- [N4675M](https://openairdocs.org/deregistered/N4675M-1960-06-15.md): Piper PA-11 · S/N 11-183 · Cancelled Jun 15, 1960 · Exported to Canada · Built 1947 · Wakefield Daniel L
- [N2110A](https://openairdocs.org/deregistered/N2110A-1959-06-26.md): Piper PA-18-135 · S/N 18-1840 · Cancelled Jun 26, 1959 · Exported to Canada · Wakerfield Daniel L
- [N5012M](https://openairdocs.org/deregistered/N5012M-1958-09-17.md): Taylorcraft BC12-D · S/N 10312 · Cancelled Sep 17, 1958 · Exported to Canada · Wakefield Daniel L
- [N94609](https://openairdocs.org/deregistered/N94609-1956-02-27.md): Ercoupe 415-CD · S/N 4710 · Cancelled Feb 27, 1956 · Built 1947 · Sihler W F Dr
- [N99567](https://openairdocs.org/deregistered/N99567-1955-10-13.md): Ercoupe 415-C · S/N 2190 · Cancelled Oct 13, 1955 · Built 1946 · Christie Edward Lionel
- [N6046M](https://openairdocs.org/deregistered/N6046M-1951-07-27.md): Stinson 108-3 · S/N 108-4046 · Cancelled Jul 27, 1951 · Exported to Canada · Built 1947 · Lake Region Flying Service Inc
- [N16422](https://openairdocs.org/deregistered/N16422-1948-04-26.md): Monocoupe 90A · S/N A-749 · Cancelled Apr 26, 1948 · Built 1937 · Toomey Glenn
- [N699V](https://openairdocs.org/deregistered/N699V-1940-02-22.md): Curtiss Wright JR CW1 · S/N 1081 · Cancelled Feb 22, 1940 · Arneson Charles Obert

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

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