# Cancelled registrations: Pewaukee, WI

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

Cancelled aircraft registrations in Pewaukee, WI.

- [N1469L](https://openairdocs.org/deregistered/N1469L-2023-02-04.md): Beech A23 · S/N M-865 · Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1965 · Meloche Cheryl M
- [N7057F](https://openairdocs.org/deregistered/N7057F-2021-10-02.md): Buckeye Powered Parachutes DREAM MACHINE 582 · S/N 3478 · Cancelled Oct 2, 2021 · Registration expired, pending cancellation · Duggan Derek Damion
- [N1473E](https://openairdocs.org/deregistered/N1473E-2020-07-17.md): Aeronca 7AC · S/N 7AC-5036 · Cancelled Jul 17, 2020 · Revoked, canceled · Built 1946 · Webster Aviation Co Inc
- [N3268E](https://openairdocs.org/deregistered/N3268E-2018-04-05.md): Aeronca 11AC · S/N 11AC1643 · Cancelled Apr 5, 2018 · Revoked, canceled · Built 1947 · Webster Avia Co Inc
- [N599MM](https://openairdocs.org/deregistered/N599MM-2018-01-25.md): Erwin Chip W MERMAID · S/N 001 · Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 2004 · Erwin Chip W
- [N871US](https://openairdocs.org/deregistered/N871US-2013-07-29.md): Government Aircraft Factories N24A · S/N N24A-72FA · Cancelled Jul 29, 2013 · Registration expired, pending cancellation · Built 1987 · Aerospace Ground Equipment Inc
- [N6078K](https://openairdocs.org/deregistered/N6078K-2013-07-16.md): Republic RC-3 · S/N 258 · Cancelled Jul 16, 2013 · Revoked, canceled · Built 1947 · Firnhaber Miles S
- [N37512](https://openairdocs.org/deregistered/N37512-2013-06-04.md): Holtz Stuart A HOLTZ B-8M · S/N 1 · Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Holtz Stuart A
- [N6206L](https://openairdocs.org/deregistered/N6206L-2013-02-11.md): American AA-1 · S/N AA1-0406 · Cancelled Feb 11, 2013 · Sale reported, canceled · Built 1970
- [N8267J](https://openairdocs.org/deregistered/N8267J-2006-10-26.md): Varga 2150A · S/N VAC-113-78 · Cancelled Oct 26, 2006 · Triennial form not returned · Built 1978 · Milkowski Gerald L
- [N995MM](https://openairdocs.org/deregistered/N995MM-2006-02-17.md): Czech Aircraft Works Spol Sro LAKE SPORT MERMAID · S/N M02/2005 · Cancelled Feb 17, 2006 · Sport Aircraft Works LLC
- [N65532](https://openairdocs.org/deregistered/N65532-2004-01-08.md): Moll Jeffrey Allen B8M · S/N 388869358 · Cancelled Jan 8, 2004 · Second triennial mailing, no response · Built 1992 · Moll Jeffery A
- [N870US](https://openairdocs.org/deregistered/N870US-1994-12-14.md): Government Aircraft Factories N24A · S/N N24A74FA · Cancelled Dec 14, 1994 · Exported to New Zealand · Aerospace Ground Equipment Inc
- [N141MR](https://openairdocs.org/deregistered/N141MR-1992-10-27.md): Ottow Randall VARIEZE · S/N 1831 · Cancelled Oct 27, 1992 · Triennial form not returned · Ottow Randall K
- [N700MA](https://openairdocs.org/deregistered/N700MA-1992-09-09.md): Mitsubishi MU-2B-60 · S/N 796SA · Cancelled Sep 9, 1992 · Exported to Canada · Roundys Inc
- [N61838](https://openairdocs.org/deregistered/N61838-1955-10-25.md): Fairchild M-62A · S/N T43-5738 · Cancelled Oct 25, 1955 · Capitol Drive Arpt Inc
- [N3087E](https://openairdocs.org/deregistered/N3087E-1955-10-17.md): Aeronca S7AC · S/N 6676 · Cancelled Oct 17, 1955 · Webster Aviation Co 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 = 'PEWAUKEE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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