# Cancelled registrations: Shakopee, MN

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

Cancelled aircraft registrations in Shakopee, MN.

- [N6438N](https://openairdocs.org/deregistered/N6438N-2019-09-05.md): Aerostar International S-66A · S/N S66A-3009 · Cancelled Sep 5, 2019 · Registration expired, pending cancellation · Built 1986 · Air America Promotions Inc
- [N410RS](https://openairdocs.org/deregistered/N410RS-2018-01-04.md): Symanitz Ronald R S-19 · S/N 070800021 · Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Symanitz Ronald R
- [N3030P](https://openairdocs.org/deregistered/N3030P-2017-11-06.md): Piper PA-23 · S/N 23-941 · Cancelled Nov 6, 2017 · Second renewal notice · Built 1957 · Beard Michael L
- [N4147P](https://openairdocs.org/deregistered/N4147P-2017-11-06.md): Piper PA-23-160 · S/N 23-1628 · Cancelled Nov 6, 2017 · First renewal notice · Built 1959 · Beard Aircraft Co
- [N2983S](https://openairdocs.org/deregistered/N2983S-2017-10-19.md): Cameron Balloons US A-105 · S/N 5133 · Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1985 · Sinnen Stephen J
- [N2058P](https://openairdocs.org/deregistered/N2058P-2017-10-11.md): Piper PA-23 · S/N 23-644 · Cancelled Oct 11, 2017 · Exported to Canada · Built 1956 · Beard Aircraft Co
- [N8759D](https://openairdocs.org/deregistered/N8759D-2017-07-18.md): Yarusso Daniel EXEC 162-F · S/N 6648 · Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 2002 · Yarusso Daniel L
- [N8021M](https://openairdocs.org/deregistered/N8021M-2017-07-06.md): Air Creation Twin 582 SL AIRCREATION TWIN SL · S/N T99080 · Cancelled Jul 6, 2017 · Registration expired, pending cancellation · Lacourse Scott A
- [N4266H](https://openairdocs.org/deregistered/N4266H-2017-03-15.md): Piper PA-14 · S/N 14-70 · Cancelled Mar 15, 2017 · Second renewal notice · Ackerman Burt Walter
- [N1602R](https://openairdocs.org/deregistered/N1602R-2012-01-09.md): Cameron Balloons US N-90 · S/N 5921 · Cancelled Jan 9, 2012 · Registration pending, pending cancellation · Built 1993
- [N9524X](https://openairdocs.org/deregistered/N9524X-2011-05-13.md): Cameron Balloons US N-105 · S/N 5622 · Cancelled May 13, 2011 · First renewal notice · Built 1990 · Sinnen Stephen J
- [N2645R](https://openairdocs.org/deregistered/N2645R-2007-08-27.md): Raven S55A · S/N S55A419 · Cancelled Aug 27, 2007 · Triennial form not returned · Built 1978 · Sinnen Stephen J
- [N6630N](https://openairdocs.org/deregistered/N6630N-1997-04-17.md): Taylorcraft 19 · S/N 413030 · Cancelled Apr 17, 1997 · Triennial form not returned · Koskovich J J
- [N5680](https://openairdocs.org/deregistered/N5680-1971-10-04.md): Bensen B-8MVW · S/N 1 · Cancelled Oct 4, 1971 · Buss Rick S
- [N75339](https://openairdocs.org/deregistered/N75339-1970-06-25.md): Piper J3C-65 · S/N 22017 · Cancelled Jun 25, 1970 · Henn Harold E
- [N34461](https://openairdocs.org/deregistered/N34461-1970-04-08.md): Aeronca 65-CA · S/N CA-14691 · Cancelled Apr 8, 1970 · Exported to Canada · Henning Walter J
- [N92477](https://openairdocs.org/deregistered/N92477-1967-09-13.md): Piper J-3C · S/N 16947 · Cancelled Sep 13, 1967 · Henn Harold & Tow Glider

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

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