# Cancelled registrations: Franklin, WI

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

Cancelled aircraft registrations in Franklin, WI.

- [N105LA](https://openairdocs.org/deregistered/N105LA-2025-12-05.md): Cirrus Design SR22 · S/N 2345 · Cancelled Dec 5, 2025 · Exported to Netherlands · Negroni Inc
- [N76AQ](https://openairdocs.org/deregistered/N76AQ-2018-06-26.md): Jungster III RK3 · S/N 1 · Cancelled Jun 26, 2018 · Registration pending, canceled · Built 1968
- [N27505](https://openairdocs.org/deregistered/N27505-2017-04-13.md): Taylorcraft BL-65 · S/N 2147 · Cancelled Apr 13, 2017 · Registration expired, pending cancellation · Built 1940 · Rogers Jeffery D
- [N98K](https://openairdocs.org/deregistered/N98K-2015-05-13.md): Cessna 210 · S/N 57392 · Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1960 · Sweet Herbert A
- [N8153B](https://openairdocs.org/deregistered/N8153B-2013-05-13.md): Cessna 172 · S/N 29953 · Cancelled May 13, 2013 · Registration expired, pending cancellation · Built 1957 · Bonney James M
- [N13089](https://openairdocs.org/deregistered/N13089-2012-06-12.md): Aeronca C-2 · S/N A-253 · Cancelled Jun 12, 2012 · Sale reported, canceled
- [N6165](https://openairdocs.org/deregistered/N6165-2009-09-18.md): Mortenson HELICOPTER · S/N 1289 · Cancelled Sep 18, 2009 · Registration pending · Built 1970
- [N33RK](https://openairdocs.org/deregistered/N33RK-2003-09-08.md): Keasler STARDUSTER I · S/N 1 · Cancelled Sep 8, 2003 · Triennial form not returned · Built 1975 · Nazimek Andrew F
- [N344TB](https://openairdocs.org/deregistered/N344TB-2003-03-20.md): Piper PA-34-220T · S/N 348133276 · Cancelled Mar 20, 2003 · Exported to Mexico · Built 1981 · Sherer Scott P
- [N441CA](https://openairdocs.org/deregistered/N441CA-1995-03-28.md): Cessna 441 · S/N 4410046 · Cancelled Mar 28, 1995 · Triennial form not returned · G G Trucking Inc
- [N377T](https://openairdocs.org/deregistered/N377T-1984-07-11.md): Smittys Termite JT-1 · S/N 1T · Cancelled Jul 11, 1984 · Administratively canceled · Eaa Aviation Foundation Inc
- [N13948](https://openairdocs.org/deregistered/N13948-1972-03-02.md): Cessna T-50 · S/N 5158 · Cancelled Mar 2, 1972 · Dr E T Ruhle
- [N5686T](https://openairdocs.org/deregistered/N5686T-1972-01-10.md): Cessna 172E · S/N 17251586 · Cancelled Jan 10, 1972 · Dietz Ralph H
- [N9131](https://openairdocs.org/deregistered/N9131-1968-08-05.md): Jodel D-9 · S/N F-3106 · Cancelled Aug 5, 1968 · Monarch Aero Corp
- [N9519K](https://openairdocs.org/deregistered/N9519K-1965-07-22.md): Stinson 108-2 · S/N 108 2519 · Cancelled Jul 22, 1965 · Rediske Edward G
- [N840](https://openairdocs.org/deregistered/N840-1965-06-03.md): Donald R Voland V-1 · S/N 1 · Cancelled Jun 3, 1965 · Experimental Aircraft Assn

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

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