# Cancelled registrations: Urbandale, IA

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

Cancelled aircraft registrations in Urbandale, IA.

- [N306TA](https://openairdocs.org/deregistered/N306TA-2022-04-02.md): Finley Wilbur H THATCHER CX4 · S/N CX159 · Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 2008 · Foster Craig L
- [N620HB](https://openairdocs.org/deregistered/N620HB-2022-03-05.md): DJI PHANTOM 3 PROFESSION · S/N P77DCG25017239 · Cancelled Mar 5, 2022 · Registration expired, pending cancellation · Birdseye Farming Inc
- [N169BE](https://openairdocs.org/deregistered/N169BE-2022-01-08.md): Precisionhawk HAWKEYE MKIII LANCAS · S/N PCN-048-201527-018-MSI · Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Birdseye Farming Inc
- [N236TB](https://openairdocs.org/deregistered/N236TB-2019-11-29.md): DJI PHANTOM 3 PROFESSION · S/N P77DCE19014858 · Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Bloomquist Tim S
- [N237TB](https://openairdocs.org/deregistered/N237TB-2019-11-29.md): DJI PHANTOM 3 PROFESSION · S/N P76DCFO1011041 · Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Bloomquist Tim
- [N646EA](https://openairdocs.org/deregistered/N646EA-2019-02-12.md): DJI INSPIRE 1 · S/N W13DCF19040200 · Cancelled Feb 12, 2019 · First renewal notice · Applied Art & Technology LLC
- [N171SL](https://openairdocs.org/deregistered/N171SL-2019-02-06.md): Leisen Steven V GLASAIR SUPER II FT · S/N 2276 · Cancelled Feb 6, 2019 · Registration expired, pending cancellation · Leisen Steve V
- [N25170](https://openairdocs.org/deregistered/N25170-2019-01-15.md): Ellis KR-1 · S/N 4346 · Cancelled Jan 15, 2019 · Registration expired, pending cancellation · Built 1977 · Eakins Keith E Sr
- [N77149](https://openairdocs.org/deregistered/N77149-2018-02-08.md): Cessna 140 · S/N 11611 · Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1946 · Noyes Richard II
- [N99963](https://openairdocs.org/deregistered/N99963-2018-02-08.md): Let BLANIK L-13 · S/N 025917 · Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1974 · Silent Knights Inc
- [N25423](https://openairdocs.org/deregistered/N25423-2013-10-31.md): Balloon Works FIREFLY 7B-15 · S/N F7B-330 · Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1992 · Harris Max G
- [N3EE](https://openairdocs.org/deregistered/N3EE-2013-04-25.md): Glaser-Dirks Flugzeugbau DG-100 · S/N E101G71 · Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1982 · Noyes Richard O II
- [N2162H](https://openairdocs.org/deregistered/N2162H-2013-04-15.md): Balloon Works FIREFLY 6B · S/N 6683 · Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1977 · Ruthenberg Donald B
- [N1543W](https://openairdocs.org/deregistered/N1543W-2012-08-07.md): Balloon Works FIREFLY 7-B · S/N 10281 · Cancelled Aug 7, 2012 · Registration expired, pending cancellation · Built 1981 · Shelley Dennis
- [N122JR](https://openairdocs.org/deregistered/N122JR-2011-04-27.md): Cirrus Design SR22 · S/N 0821 · Cancelled Apr 27, 2011 · Exported to Australia · Built 2004 · Perdue Aviation LLC
- [N3314](https://openairdocs.org/deregistered/N3314-2007-07-20.md): Hayes STARDUSTER TOO · S/N 814 · Cancelled Jul 20, 2007 · Triennial form not returned · Built 1974 · Hayes James T Jr
- [N4660F](https://openairdocs.org/deregistered/N4660F-2000-12-14.md): Thompson John O T-BIRD I · S/N 972302 · Cancelled Dec 14, 2000 · Triennial form not returned · Thompson John O
- [N56306](https://openairdocs.org/deregistered/N56306-2000-12-07.md): Piper PA-32-300 · S/N 32-7340170 · Cancelled Dec 7, 2000 · Triennial form not returned · Foxtrot Flying Club Inc
- [N7719G](https://openairdocs.org/deregistered/N7719G-1975-08-20.md): Cessna 172L · S/N 17259419 · Cancelled Aug 20, 1975 · Exported to Canada · Ditsworth Craig A

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

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