# Cancelled registrations: East Troy, WI

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

Cancelled aircraft registrations in East Troy, WI.

- [N882NY](https://openairdocs.org/deregistered/N882NY-2024-04-13.md): Bell 206B · S/N 882 · Cancelled Apr 13, 2024 · Registration pending, canceled · Built 1972
- [N67148](https://openairdocs.org/deregistered/N67148-2024-03-23.md): Bell 206B · S/N 5116 · Cancelled Mar 23, 2024 · Sale reported, canceled · Built 1994
- [N368A](https://openairdocs.org/deregistered/N368A-2023-03-04.md): Mooney M-18L · S/N 29 · Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1949 · Merschdorf Albert
- [N500MJ](https://openairdocs.org/deregistered/N500MJ-2021-10-02.md): Piper PA-32RT-300T · S/N 32R-7987051 · Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Built 1978 · Dague Ronald S
- [N4393J](https://openairdocs.org/deregistered/N4393J-2020-05-01.md): Shepherd Reginald W FIRESTAR II · S/N FS100 · Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1994 · Shepherd Reginald W
- [N5241](https://openairdocs.org/deregistered/N5241-2020-01-17.md): Peterson Starduster PSA 100 · S/N 1 · Cancelled Jan 17, 2020 · Revoked, canceled · Peterson Richard Edward
- [N44262](https://openairdocs.org/deregistered/N44262-2019-07-26.md): Buckeye DM 582 · S/N 3424 · Cancelled Jul 26, 2019 · Registration expired, pending cancellation · Built 1996 · Pontell Walter A
- [N529DW](https://openairdocs.org/deregistered/N529DW-2018-11-28.md): Robinson Helicopter R44 · S/N 1109 · Cancelled Nov 28, 2018 · Built 2001 · Mf Helicopters LLC
- [N1879](https://openairdocs.org/deregistered/N1879-2018-01-03.md): Scott IRONSIDES XS-1 · S/N 1 · Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1969 · Scott Ronald G
- [N2579H](https://openairdocs.org/deregistered/N2579H-2013-08-19.md): Ercoupe 415-C · S/N 3204 · Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1946
- [N76722](https://openairdocs.org/deregistered/N76722-2013-08-19.md): Cessna 120 · S/N 11154 · Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1946
- [N20EF](https://openairdocs.org/deregistered/N20EF-2013-08-13.md): Swearingen SA-26AT · S/N T26-157 · Cancelled Aug 13, 2013 · Sale reported, canceled · Built 1969
- [N152DE](https://openairdocs.org/deregistered/N152DE-2013-07-02.md): Ennevor Daniel A ROTORWAY EXEC · S/N E01 · Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Kannard Ken K
- [N567B](https://openairdocs.org/deregistered/N567B-2013-06-18.md): Beech A35 · S/N D-1587 · Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1948 · Rennick Neil J
- [N461K](https://openairdocs.org/deregistered/N461K-2013-04-30.md): Cessna 310F · S/N 310-0053 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Rennick Neil J
- [N101FX](https://openairdocs.org/deregistered/N101FX-2009-08-21.md): Short Bros. & Harland SC7 SERIES 3 · S/N SH1845 · Cancelled Aug 21, 2009 · Triennial form not returned · Built 1967 · North Star Air Cargo Inc
- [N67845](https://openairdocs.org/deregistered/N67845-2008-06-18.md): Cessna 152 · S/N 15282054 · Cancelled Jun 18, 2008 · Exported to Australia · Built 1978 · Coolidge Timothy
- [N442GS](https://openairdocs.org/deregistered/N442GS-2006-08-04.md): Robinson Helicopter R44 ASTRO · S/N 0683 · Cancelled Aug 4, 2006 · Built 1999 · Ww Helicopters LLC
- [N246AN](https://openairdocs.org/deregistered/N246AN-2003-12-30.md): Nicoson Alan E ANTARES MA-33 · S/N NIC001 · Cancelled Dec 30, 2003 · Built 2003 · Nicoson Alan E
- [N269V](https://openairdocs.org/deregistered/N269V-1992-09-09.md): Hughes 269C · S/N 300883 · Cancelled Sep 9, 1992 · Exported to Canada · Voland Donald R
- [N5643R](https://openairdocs.org/deregistered/N5643R-1991-10-15.md): Cessna 172F · S/N 17253268 · Cancelled Oct 15, 1991 · Triennial form not returned · August Dorothy D
- [N304L](https://openairdocs.org/deregistered/N304L-1979-10-12.md): Mitsubishi MU-2B-20 · S/N 137 · Cancelled Oct 12, 1979 · Built 1968 · Business Aircraft Leasing Inc

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

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