# Cancelled registrations: Burlington, IA

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

Cancelled aircraft registrations in Burlington, IA.

- [N256L](https://openairdocs.org/deregistered/N256L-2022-11-24.md): Connary MONARCH · S/N B211 · Cancelled Nov 24, 2022 · Built 2006 · Hester Dennis R
- [N943DM](https://openairdocs.org/deregistered/N943DM-2021-10-30.md): Magnus Don TITAN TORNADO 1 · S/N T96XKY60HK0206 · Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Hoffman Mike W
- [N6781Z](https://openairdocs.org/deregistered/N6781Z-2019-07-05.md): Mcmillan Robert D JR ZODIAT CH 601 HD · S/N 6-3226 HD · Cancelled Jul 5, 2019 · Registration expired, pending cancellation · Built 1997 · Mcmillan Robert D Jr
- [N1016G](https://openairdocs.org/deregistered/N1016G-2019-05-04.md): Air Tractor AT-402 · S/N 402-0720 · Cancelled May 4, 2019 · Registration expired, pending cancellation · Built 1989 · Watson Mark J
- [N51475](https://openairdocs.org/deregistered/N51475-2018-05-30.md): Fairchild M-62A · S/N T423338 · Cancelled May 30, 2018 · Revoked, canceled · Built 1942 · Pt-19 Flying Club Inc
- [N2161](https://openairdocs.org/deregistered/N2161-2018-04-19.md): Smith Miniplane IWG · S/N 4321 · Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 1969 · Krieger Roger J
- [N2565W](https://openairdocs.org/deregistered/N2565W-2017-10-19.md): Mooney M20E · S/N 928 · Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1965 · Beriault Michael E
- [N4424P](https://openairdocs.org/deregistered/N4424P-2014-11-13.md): Lewis Floyd Earl HI MAX · S/N 849 · Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1992 · Lewis Floyd E
- [N412LF](https://openairdocs.org/deregistered/N412LF-2013-08-22.md): Lewis Floyd E FIRST STRIKE BOBCAT · S/N 412 · Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1994
- [N110SH](https://openairdocs.org/deregistered/N110SH-2013-06-18.md): Hemphill Steven BABY LAKES · S/N 110653 · Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Hemphill Steven L
- [N935FM](https://openairdocs.org/deregistered/N935FM-2013-06-12.md): Ellefson Robert J TIERRA · S/N 10395 · Cancelled Jun 12, 2013 · Registration expired, pending cancellation · Built 1983 · Ellafson Robert James
- [N4248A](https://openairdocs.org/deregistered/N4248A-2013-06-11.md): Raven Industries RALLY RX7 · S/N RX7-355 · Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1984 · Cook Robert J
- [N25072](https://openairdocs.org/deregistered/N25072-2012-08-21.md): Perkins BARNETT J4B · S/N 082 · Cancelled Aug 21, 2012 · Sale reported, canceled · Built 1979
- [N25581](https://openairdocs.org/deregistered/N25581-2012-08-21.md): Bauer BENSEN B-8M · S/N 66660 · Cancelled Aug 21, 2012 · Sale reported, canceled · Built 1975
- [N8182](https://openairdocs.org/deregistered/N8182-2011-11-09.md): Pitts Special S-1C · S/N K-01 · Cancelled Nov 9, 2011 · Registration pending · Built 1970
- [N65041](https://openairdocs.org/deregistered/N65041-2011-05-17.md): Boeing/Wright Joe W B75N1 · S/N 75-8025A · Cancelled May 17, 2011 · Exported to New Zealand · Built 1943 · Bangert Kurt R
- [N1195X](https://openairdocs.org/deregistered/N1195X-2010-11-02.md): Piper PA-28-151 · S/N 28-7515324 · Cancelled Nov 2, 2010 · Exported to Argentina · Built 1975 · Remmers Aviation Inc
- [N7750J](https://openairdocs.org/deregistered/N7750J-2010-08-02.md): Diewold Jeff RV6 · S/N 23324 · Cancelled Aug 2, 2010 · Triennial form not returned · Built 2004 · Diewold Jeff E
- [N1045Y](https://openairdocs.org/deregistered/N1045Y-2002-10-07.md): Hester Dennis R STREAK · S/N 0001 · Cancelled Oct 7, 2002 · Second triennial mailing, no response · Hester Dennis R
- [N5903S](https://openairdocs.org/deregistered/N5903S-2000-01-12.md): Beech 95-C55 · S/N TE-110 · Cancelled Jan 12, 2000 · Triennial form not returned · Bonway Inc
- [N26009](https://openairdocs.org/deregistered/N26009-1991-11-21.md): Piper PA-38-112 · S/N 3881A0098 · Cancelled Nov 21, 1991 · Triennial form not returned · Reemers Aviation Inc
- [N7431F](https://openairdocs.org/deregistered/N7431F-1983-01-17.md): Hughes 269C · S/N 260472 · Cancelled Jan 17, 1983 · Exported to New Zealand · Tlc Inc
- [N8789M](https://openairdocs.org/deregistered/N8789M-1975-10-17.md): Beech A23 · S/N M-573 · Cancelled Oct 17, 1975 · Exported to Canada · Neumann Leonard C
- [N3401A](https://openairdocs.org/deregistered/N3401A-1970-07-15.md): Piper PA-22-135 · S/N 22-1671 · Cancelled Jul 15, 1970 · Bennett G L
- [N5878D](https://openairdocs.org/deregistered/N5878D-1970-06-25.md): Piper PA-22-150 · S/N 22-4559 · Cancelled Jun 25, 1970 · Donald R Gugeler
- [N286Y](https://openairdocs.org/deregistered/N286Y-1959-09-04.md): Hartman ART J HARTMAN · S/N 1910-1 · Cancelled Sep 4, 1959 · Built 1938 · Arthur J Hartman
- [N4106](https://openairdocs.org/deregistered/N4106-1959-07-10.md): Mooney M-18LA · S/N 140 · Cancelled Jul 10, 1959 · Exported to Canada · Built 1953 · Delaney R H And Roberts Hugh F
- [N61877](https://openairdocs.org/deregistered/N61877-1956-02-15.md): Fairchild M-62A · S/N T43-5255 · Cancelled Feb 15, 1956 · Mitchell James W
- [N64532](https://openairdocs.org/deregistered/N64532-1949-12-07.md): Cessna UC-78 · S/N 3386 · Cancelled Dec 7, 1949 · Hartman Flying Service
- [N26100](https://openairdocs.org/deregistered/N26100-1948-07-06.md): Piper J3L-65 · S/N 4040 · Cancelled Jul 6, 1948 · Built 1939 · Hartman Flying Service
- [N13376](https://openairdocs.org/deregistered/N13376-1948-04-06.md): Aeronca C-2 · S/N 1AA · Cancelled Apr 6, 1948 · Hartman Flying Service
- [N221V](https://openairdocs.org/deregistered/N221V-1948-02-27.md): Moth 60-GM · S/N 147 · Cancelled Feb 27, 1948 · Marguerite E Kowski
- [N14110](https://openairdocs.org/deregistered/N14110-1937-03-24.md): Aeronca C-3 · S/N A-410 · Cancelled Mar 24, 1937 · Hartman A 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 = 'IA' AND d.registrant_city = 'BURLINGTON'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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