# Cancelled registrations: Clear Lake, MN

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

Cancelled aircraft registrations in Clear Lake, MN.

- [N4456V](https://openairdocs.org/deregistered/N4456V-2022-12-31.md): Goeb Louie P ZENITH 250 · S/N 1 · Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Leaders Bob O
- [N56AW](https://openairdocs.org/deregistered/N56AW-2022-12-31.md): Beech 95-B55 (T42A) · S/N TC-110 · Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Leaders Bob O
- [N13735](https://openairdocs.org/deregistered/N13735-2022-12-03.md): Cessna 180K · S/N 18053171 · Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Leaders Bob
- [N777MJ](https://openairdocs.org/deregistered/N777MJ-2022-11-05.md): Owens Sheridan MIDGET MUSTANG · S/N M-1-941 · Cancelled Nov 5, 2022 · Registration expired, pending cancellation · Leaders Bob
- [N8921F](https://openairdocs.org/deregistered/N8921F-2021-12-04.md): Hughes 269A · S/N 0303 · Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Leaders Bob
- [N11327](https://openairdocs.org/deregistered/N11327-2021-08-03.md): Cessna 150L · S/N 15075331 · Cancelled Aug 3, 2021 · Registration expired, pending cancellation · Built 1973 · Leaders Flying Service Inc
- [N11DS](https://openairdocs.org/deregistered/N11DS-2015-05-06.md): Piper PA-22-150 · S/N 22-3383 · Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1965 · Seibert Robert P
- [N80357](https://openairdocs.org/deregistered/N80357-2014-11-19.md): Cessna 172M · S/N 17266546 · Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1976 · Leaders Flying Service Inc
- [N6953E](https://openairdocs.org/deregistered/N6953E-2014-09-03.md): Cessna 175A · S/N 56453 · Cancelled Sep 3, 2014 · Revoked, canceled · Built 1959 · Leaders Flying Service Inc
- [N2962P](https://openairdocs.org/deregistered/N2962P-2013-02-25.md): Piper PA-22-150 · S/N 22-3235 · Cancelled Feb 25, 2013 · Registration expired, pending cancellation · Built 1955 · Seibert Robert P
- [N3149D](https://openairdocs.org/deregistered/N3149D-2012-09-27.md): Cessna 180 · S/N 31947 · Cancelled Sep 27, 2012 · Registration expired, pending cancellation · Built 1955 · Peterson E A
- [N2596Y](https://openairdocs.org/deregistered/N2596Y-2009-07-14.md): Cessna 172D · S/N 17249896 · Cancelled Jul 14, 2009 · Registration revoked · Built 1962 · Leaders Flying Service Inc
- [N1403D](https://openairdocs.org/deregistered/N1403D-2009-06-30.md): Cessna 170A · S/N 20110 · Cancelled Jun 30, 2009 · Registration revoked · Built 1951 · Leaders Flying Service Inc
- [N63474](https://openairdocs.org/deregistered/N63474-1985-10-08.md): Cessna 150M · S/N 15077342 · Cancelled Oct 8, 1985 · Hayes Del
- [N7691J](https://openairdocs.org/deregistered/N7691J-1979-11-14.md): Piper PA-28R-180 · S/N 28R-30845 · Cancelled Nov 14, 1979 · Exported to Canada · Leaders Flying Service Inc
- [N7352G](https://openairdocs.org/deregistered/N7352G-1979-05-04.md): Cessna 172K · S/N 17259052 · Cancelled May 4, 1979 · Exported to Canada · Leaders Flying Ser Inc
- [N7824G](https://openairdocs.org/deregistered/N7824G-1975-06-04.md): Cessna 172 · S/N 17259524 · Cancelled Jun 4, 1975 · Exported to Canada · Leaders Bob
- [N71289](https://openairdocs.org/deregistered/N71289-1974-12-03.md): Luscombe 8A · S/N 2716 · Cancelled Dec 3, 1974 · Exported to Canada · Leaders Bob
- [N266HC](https://openairdocs.org/deregistered/N266HC-1972-11-22.md): Boeing D75N1 · S/N 75-3919 · Cancelled Nov 22, 1972 · Leaders Flying Service Inc
- [N89459](https://openairdocs.org/deregistered/N89459-1972-11-02.md): Cessna 140 · S/N 8491 · Cancelled Nov 2, 1972 · Exported to Canada · Leaders Flying Service Inc
- [N2614D](https://openairdocs.org/deregistered/N2614D-1971-07-16.md): Cessna 170B · S/N 20766 · Cancelled Jul 16, 1971 · Exported to Canada · Built 1952 · Leaders Bob
- [N2601V](https://openairdocs.org/deregistered/N2601V-1970-07-02.md): Cessna 170 · S/N 18241 · Cancelled Jul 2, 1970 · Peterson A Edgar
- [N27014](https://openairdocs.org/deregistered/N27014-1959-09-03.md): Piper J3L-65 · S/N 4315 · Cancelled Sep 3, 1959 · David Scoles

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

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