# Cancelled registrations: Elkhorn, WI

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

Cancelled aircraft registrations in Elkhorn, WI.

- [N20KD](https://openairdocs.org/deregistered/N20KD-2018-02-27.md): Robinson Helicopter R44 · S/N 0983 · Cancelled Feb 27, 2018 · Registration expired, pending cancellation · Built 2001 · Deakins Back Nine Dairy LLC
- [N9681R](https://openairdocs.org/deregistered/N9681R-2018-01-10.md): Robinson Helicopter R44 · S/N 1046 · Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 2001 · Back Nine Aerial LLC
- [N8343P](https://openairdocs.org/deregistered/N8343P-2018-01-09.md): Robinson Helicopter R44 · S/N 0313 · Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1996 · Back Nine Aerial LLC
- [N9567Z](https://openairdocs.org/deregistered/N9567Z-2017-11-21.md): Beech C-45H · S/N AF-877 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1960 · Gruenwald Ronald B
- [N1036Z](https://openairdocs.org/deregistered/N1036Z-2016-09-08.md): Taylorcraft B-2 · S/N 11 · Cancelled Sep 8, 2016 · Registration pending, canceled
- [N570BC](https://openairdocs.org/deregistered/N570BC-2015-07-02.md): Found Acft Canada FBA-2C1 · S/N 57 · Cancelled Jul 2, 2015 · Exported to Australia · Built 2005 · Alford Lacey
- [N79527](https://openairdocs.org/deregistered/N79527-2015-04-30.md): Cessna 172K · S/N 17258152 · Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1969 · Clark Allan
- [N3688T](https://openairdocs.org/deregistered/N3688T-2014-10-02.md): Taylorcraft F19 · S/N F-095 · Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 1977 · Wottreng Thomas C
- [N96308](https://openairdocs.org/deregistered/N96308-2013-03-20.md): Taylorcraft BC12-D · S/N 8608 · Cancelled Mar 20, 2013 · Sale reported, canceled · Built 1946
- [N75237](https://openairdocs.org/deregistered/N75237-2013-02-21.md): Boeing A75 · S/N 75-3463 · Cancelled Feb 21, 2013 · Sale reported, canceled · Built 1946
- [N570MD](https://openairdocs.org/deregistered/N570MD-2012-11-09.md): Robinson Helicopter R44 · S/N 0192 · Cancelled Nov 9, 2012 · Registration expired, pending cancellation · Built 1995 · Md Helicopter Services LLC
- [N5844A](https://openairdocs.org/deregistered/N5844A-1983-08-15.md): Cessna 172 · S/N 28444 · Cancelled Aug 15, 1983 · Longhorn Arthur G
- [N44252](https://openairdocs.org/deregistered/N44252-1969-11-04.md): Taylorcraft BC12-D1 · S/N 10052 · Cancelled Nov 4, 1969 · Quinney Ralph D
- [N51516](https://openairdocs.org/deregistered/N51516-1965-05-20.md): Piper J3C-65 · S/N 10218 · Cancelled May 20, 1965 · Shaputis John V
- [N9761H](https://openairdocs.org/deregistered/N9761H-1956-02-14.md): Fairchild M-62A-3 · S/N FZ298 · Cancelled Feb 14, 1956 · Kline Howard L
- [N15754](https://openairdocs.org/deregistered/N15754-1948-07-28.md): Prentice Alfred James AERO-MARINE · S/N 1000 · Cancelled Jul 28, 1948 · Built 1936 · Malsch Glenn J

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

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