# Cancelled registrations: Waupaca, WI

A list on [Waupaca, WI](https://openairdocs.org/faa-place/WI/Waupaca.md).

Cancelled aircraft registrations in Waupaca, WI.

- [N9310E](https://openairdocs.org/deregistered/N9310E-2021-10-30.md): Aeronca 11AC · S/N 11AC-948 · Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1948 · Unertl Ronald W
- [N407KJ](https://openairdocs.org/deregistered/N407KJ-2021-09-04.md): Slocum William HAWK CLASSIC · S/N 84HSC929 · Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Built 2007 · Jaschob Kenneth L
- [N301AA](https://openairdocs.org/deregistered/N301AA-2020-05-01.md): Honeycomb AGDRONE · S/N 98FB1D0 · Cancelled May 1, 2020 · Registration expired, pending cancellation · Robinson Jeffrey Aaron
- [N302AA](https://openairdocs.org/deregistered/N302AA-2020-05-01.md): DJI INSPIRE 1 · S/N W13DCB04020614 · Cancelled May 1, 2020 · Registration expired, pending cancellation · Robinson Jeffrey Aaron
- [N616K](https://openairdocs.org/deregistered/N616K-2018-03-27.md): Piper PA-20 · S/N 20-438 · Cancelled Mar 27, 2018 · Registration expired, pending cancellation · Built 1950 · Unertil Ronald W
- [N77RU](https://openairdocs.org/deregistered/N77RU-2018-02-23.md): Unertl EAA BIPLANE · S/N 1 · Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1977 · Unertl Ronald W
- [N727SZ](https://openairdocs.org/deregistered/N727SZ-2017-06-30.md): Zastoupil Scott A CHALLENGER II · S/N 4941138 · Cancelled Jun 30, 2017 · Registration expired, pending cancellation · Zastoupil Scott A
- [N5898Z](https://openairdocs.org/deregistered/N5898Z-2015-05-06.md): Piper PA-22-108 · S/N 22-9763 · Cancelled May 6, 2015 · Registration expired, pending cancellation · Unterl Ron
- [N9952W](https://openairdocs.org/deregistered/N9952W-2013-07-29.md): Piper PA-28-140 · S/N 28-23498 · Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1967 · Ferguson Carl R
- [N8188L](https://openairdocs.org/deregistered/N8188L-2013-04-29.md): Stubblefield Terry Irvin CHALLENGER II · S/N CH2-04941138 · Cancelled Apr 29, 2013 · Sale reported, pending cancellation
- [N911PE](https://openairdocs.org/deregistered/N911PE-2012-06-14.md): Quicksilver GT-500 · S/N 288 · Cancelled Jun 14, 2012 · Sale reported, canceled
- [N5236E](https://openairdocs.org/deregistered/N5236E-1994-09-06.md): Cessna 172N · S/N 17271788 · Cancelled Sep 6, 1994 · Exported to Germany · Gusmer John H
- [N560CM](https://openairdocs.org/deregistered/N560CM-1992-12-15.md): Aero Commander 560-F · S/N 131161 · Cancelled Dec 15, 1992 · Triennial form not returned · Mclaughlin Construction Co Inc
- [N2001Z](https://openairdocs.org/deregistered/N2001Z-1969-05-05.md): Cessna 150C · S/N 15059801 · Cancelled May 5, 1969 · Exported to Canada · Pollack Aircraft Sales Inc
- [N23448](https://openairdocs.org/deregistered/N23448-1948-06-15.md): Piper J3F-50 · S/N 3177 · Cancelled Jun 15, 1948 · H T Flying Service
- [N55](https://openairdocs.org/deregistered/N55-1929-09-06.md): Standard J-1 · S/N 001 · Cancelled Sep 6, 1929 · West Elwyn V
- [N2478](https://openairdocs.org/deregistered/N2478-1927-06-05.md): West Elwyn STANDARD J-1 · S/N A-794 · Cancelled Jun 5, 1927 · West Elwyn

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

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