# Cancelled registrations: Lake Geneva, WI

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

Cancelled aircraft registrations in Lake Geneva, WI.

- [N5582M](https://openairdocs.org/deregistered/N5582M-2022-04-20.md): Piper PA-16 · S/N 16-40 · Cancelled Apr 20, 2022 · Registration expired, pending cancellation · Foley Anne M
- [N2896M](https://openairdocs.org/deregistered/N2896M-2021-12-04.md): Piper PA-12 · S/N 12-1315 · Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1946 · Milne Sales And Services LLC
- [N542B](https://openairdocs.org/deregistered/N542B-2021-06-09.md): Schempp-Hirth DISCUS B · S/N 195 · Cancelled Jun 9, 2021 · Exported to Canada · Built 1987 · Strong Cha K
- [N40072](https://openairdocs.org/deregistered/N40072-2020-02-28.md): Beech UC-45J · S/N 039258 · Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1945 · Zbierski Hank F
- [N9196](https://openairdocs.org/deregistered/N9196-2020-02-28.md): Beech RC-45J · S/N 039196 · Cancelled Feb 28, 2020 · Registration expired, pending cancellation · Built 1968 · Zbierski Hank F
- [N7423R](https://openairdocs.org/deregistered/N7423R-2019-09-06.md): DJI PHANTOM 3 PROFESSION · S/N P76DCF28010987 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Koehnke Richard E
- [N7428K](https://openairdocs.org/deregistered/N7428K-2019-09-06.md): DJI INSPIRE 1 · S/N W13DCH19040267 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Koehnke Richard E
- [N104TK](https://openairdocs.org/deregistered/N104TK-2018-06-26.md): Powrachute PC 2000 · S/N A 66 POW · Cancelled Jun 26, 2018 · Registration pending, canceled · Built 2001 · Negistration Pending
- [N6352U](https://openairdocs.org/deregistered/N6352U-2018-03-28.md): Aerostar International S-60A · S/N S60A-3160 · Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Lake Geneva Balloon Company LLC
- [N154CP](https://openairdocs.org/deregistered/N154CP-2018-03-21.md): Powrachute PC 2000 · S/N A205POW · Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1999 · Pillman Francis C
- [N5087P](https://openairdocs.org/deregistered/N5087P-2018-02-08.md): Piper PA-24-180 · S/N 24-93 · Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1958 · Ketterhagen Donald W
- [N90583](https://openairdocs.org/deregistered/N90583-2015-05-13.md): Balloon Works FIREFLY 9 · S/N F9-038 · Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1990 · Elliott Terry
- [N51SK](https://openairdocs.org/deregistered/N51SK-2014-10-14.md): Sisk BD-5 · S/N 1632 · Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Built 1994 · Sisk Vadie G
- [N74172](https://openairdocs.org/deregistered/N74172-2013-05-23.md): Balloon Works FIREFLY 7 · S/N F7-309 · Cancelled May 23, 2013 · Registration expired, pending cancellation · Elliott Terry
- [N9051C](https://openairdocs.org/deregistered/N9051C-2013-05-17.md): Heath PARASOL SPECIAL · S/N S-101 · Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1955 · Sylvester Corwin L
- [N7221](https://openairdocs.org/deregistered/N7221-2013-05-06.md): Starduster SA-100 · S/N 1 · Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1967 · Seabright Lyle F
- [N1533C](https://openairdocs.org/deregistered/N1533C-2013-04-11.md): Balloon Works FIREFLY 8-24 · S/N 10202 · Cancelled Apr 11, 2013 · Registration expired, pending cancellation · Built 1980 · Lake Geneva Balloonport Inc
- [N5346A](https://openairdocs.org/deregistered/N5346A-2013-01-30.md): Cessna 310A · S/N 38030A · Cancelled Jan 30, 2013 · Sale reported, pending cancellation · Built 1957
- [N7162E](https://openairdocs.org/deregistered/N7162E-2012-05-24.md): Balloon Works FIREFLY 9 · S/N F9-076 · Cancelled May 24, 2012 · Registration expired, pending cancellation · Built 2001 · Elliott Terry L DBA
- [N1703Y](https://openairdocs.org/deregistered/N1703Y-2007-05-02.md): Beech B95A · S/N TD-498 · Cancelled May 2, 2007 · Triennial form not returned · Built 1962 · Gns LLC
- [N994RV](https://openairdocs.org/deregistered/N994RV-2003-10-28.md): Laferriere Bernard VANS RV-4 · S/N 2743 · Cancelled Oct 28, 2003 · Triennial form not returned · Built 1992 · Anderson John C
- [N9220H](https://openairdocs.org/deregistered/N9220H-2001-10-09.md): Stinson 10A · S/N 8067 · Cancelled Oct 9, 2001 · Built 1941 · Faas C Jack
- [N5293W](https://openairdocs.org/deregistered/N5293W-2001-03-29.md): Piper PA-28 · S/N 28-344 · Cancelled Mar 29, 2001 · Second triennial mailing, no response · Radtke Jeff A
- [N1197T](https://openairdocs.org/deregistered/N1197T-2000-08-11.md): Jacobsen Jeffrey L AVID FLYER MARK IV · S/N 1535D · Cancelled Aug 11, 2000 · Triennial form not returned · Jacobsen Jeffrey L
- [N22193](https://openairdocs.org/deregistered/N22193-1974-07-17.md): Aeronca 65-C · S/N C-2979 · Cancelled Jul 17, 1974 · Jon Wayne Speckman
- [N1050Z](https://openairdocs.org/deregistered/N1050Z-1971-12-01.md): Jodel D-9 · S/N F-3032 · Cancelled Dec 1, 1971 · Whiting Lawrence H Jr
- [N83637](https://openairdocs.org/deregistered/N83637-1971-09-08.md): Aeronca 7AC · S/N 7AC-2315 · Cancelled Sep 8, 1971 · Built 1946 · Strand Peter F
- [N6586A](https://openairdocs.org/deregistered/N6586A-1971-02-08.md): Cessna 180 · S/N 32483 · Cancelled Feb 8, 1971 · Tomaske Milton A DBA Lakeland Flying Service
- [N87236](https://openairdocs.org/deregistered/N87236-1965-05-20.md): Engineering & Research 415-C · S/N 409 · Cancelled May 20, 1965 · Tomaske Milton
- [N85642](https://openairdocs.org/deregistered/N85642-1952-03-26.md): Aeronca 7AC · S/N 7AC-4386 · Cancelled Mar 26, 1952 · Bob Leonard
- [N672H](https://openairdocs.org/deregistered/N672H-1949-04-12.md): Travel Air E-4000 · S/N 1230 · Cancelled Apr 12, 1949 · Tomaske Milton

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

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