# Cancelled registrations: Sullivan, WI

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

Cancelled aircraft registrations in Sullivan, WI.

- [N3092G](https://openairdocs.org/deregistered/N3092G-2019-01-30.md): Bell 47J-2A · S/N 3309 · Cancelled Jan 30, 2019 · Registration expired, pending cancellation · Built 1965 · Mcdermott Enterprises DBA
- [N49HB](https://openairdocs.org/deregistered/N49HB-2018-04-19.md): Bell 47G-2A-1 · S/N 3562 · Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Mcdermott Wayne E
- [N52HB](https://openairdocs.org/deregistered/N52HB-2018-03-06.md): Bell 47G-2A · S/N 3244 · Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1964 · Mcdermott Enterprises Inc DBA
- [N73205](https://openairdocs.org/deregistered/N73205-2018-03-06.md): Bell 47G-2A · S/N 2695 · Cancelled Mar 6, 2018 · Registration expired, pending cancellation · Built 1961 · Mcdermott Enterprises Inc
- [N16041](https://openairdocs.org/deregistered/N16041-2014-11-26.md): Bell 47J · S/N 1604M · Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1956 · Mcdermott Enterprises Inc DBA
- [N46HB](https://openairdocs.org/deregistered/N46HB-2014-09-03.md): Bell TH-13T · S/N 65-8077 · Cancelled Sep 3, 2014 · Sale reported, canceled · Built 1965
- [N4191R](https://openairdocs.org/deregistered/N4191R-2013-06-18.md): Raven Industries S-66A · S/N S66A-131 · Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Balloons Unlimited Of Wisconsin Inc
- [N83LC](https://openairdocs.org/deregistered/N83LC-2013-06-12.md): Beech 58P · S/N TJ-289 · Cancelled Jun 12, 2013 · Sale reported, pending cancellation · Built 1980
- [N8877F](https://openairdocs.org/deregistered/N8877F-2013-05-10.md): Hughes 269A · S/N 73-0254 · Cancelled May 10, 2013 · Sale reported, canceled · Built 1963
- [N7812B](https://openairdocs.org/deregistered/N7812B-2013-05-09.md): Bell 47J · S/N 1774 · Cancelled May 9, 2013 · Registration expired, pending cancellation · Built 1959 · Ideal Helicopter Service
- [N4797K](https://openairdocs.org/deregistered/N4797K-2012-02-02.md): Cessna P210N · S/N P21000324 · Cancelled Feb 2, 2012 · Triennial form not returned · Built 1979 · Mcdermott Wayne E
- [N1258F](https://openairdocs.org/deregistered/N1258F-2003-08-01.md): Balloon Works FIREFLY 7 · S/N 170 · Cancelled Aug 1, 2003 · Triennial form not returned · Built 1974 · Asp Peter H
- [N3185G](https://openairdocs.org/deregistered/N3185G-1995-02-01.md): Bell 206B · S/N 721 · Cancelled Feb 1, 1995 · Triennial form not returned · Mcdermott Enterprises Inc DBA
- [N217GP](https://openairdocs.org/deregistered/N217GP-1995-01-05.md): Bell 206B · S/N 2350 · Cancelled Jan 5, 1995 · Exported to South Africa · Mcdermott Enterprises Inc DBA
- [N16913](https://openairdocs.org/deregistered/N16913-1993-10-13.md): Bell 206B · S/N 2341 · Cancelled Oct 13, 1993 · Exported to Brazil · Ideal Helicopter Services
- [N5015K](https://openairdocs.org/deregistered/N5015K-1993-06-10.md): Bell 206B · S/N 2611 · Cancelled Jun 10, 1993 · Exported to Venezuela · Ideal Helicopter Svcs

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

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