# Cancelled registrations: Ames, IA

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

Cancelled aircraft registrations in Ames, IA.

Page 1 of 2 · 60 registrations

- [N915BG](https://openairdocs.org/deregistered/N915BG-2022-06-04.md): DJI PHANTOM 2 · S/N PH615159652 · Cancelled Jun 4, 2022 · Registration expired, pending cancellation · Bodholdt And Grummer Productions Inc
- [N849SU](https://openairdocs.org/deregistered/N849SU-2021-09-04.md): DJI PHANTOM 4 PRO · S/N 0AXCE8W0A30398 · Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Iowa State University
- [N8193D](https://openairdocs.org/deregistered/N8193D-2021-03-06.md): DJI MAVIC PRO · S/N 08QDE3N01203NE · Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Iowa State University
- [N822MA](https://openairdocs.org/deregistered/N822MA-2021-01-30.md): DJI PHANTOM 4 PRO · S/N 0AXCE320A30445 · Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Iowa State University
- [N831VS](https://openairdocs.org/deregistered/N831VS-2021-01-30.md): DJI PHANTOM 4 PRO · S/N 0AXCE680A30562 · Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Iowa State University
- [N949CG](https://openairdocs.org/deregistered/N949CG-2020-12-12.md): Cirrus Design SR22 · S/N 2803 · Cancelled Dec 12, 2020 · Second renewal notice · Built 2007 · Wassaire Inc
- [N818NU](https://openairdocs.org/deregistered/N818NU-2020-09-04.md): DJI PHANTOM 4 · S/N 07DDD5F0A10594 · Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Iowa State University
- [N4483H](https://openairdocs.org/deregistered/N4483H-2020-06-02.md): Piper PA-15 · S/N 15-272 · Cancelled Jun 2, 2020 · Registration expired, pending cancellation · Built 1948 · Ledet Jack Wayne
- [N71733](https://openairdocs.org/deregistered/N71733-2020-01-31.md): Luscombe 8A · S/N 3160 · Cancelled Jan 31, 2020 · Revoked, canceled · Built 1946 · Hawkins Charles E
- [N7446U](https://openairdocs.org/deregistered/N7446U-2019-10-05.md): Sensefly EBEE · S/N EB-03-804 · Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Iowa State University
- [N666XL](https://openairdocs.org/deregistered/N666XL-2019-09-06.md): DJI PHANTOM 3 PROFESSION · S/N P76DCD19010560 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Lankford Terry L
- [N710DT](https://openairdocs.org/deregistered/N710DT-2019-09-06.md): DJI PHANTOM 2 VISION + · S/N PH645440143 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Lankford Terry L
- [N744XS](https://openairdocs.org/deregistered/N744XS-2019-09-06.md): Sensefly EBEE · S/N EB-02-617 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Iowa State University
- [N32442](https://openairdocs.org/deregistered/N32442-2018-08-23.md): Rearwin 8135 · S/N 867 · Cancelled Aug 23, 2018 · Registration pending, canceled · Built 1941
- [N5613H](https://openairdocs.org/deregistered/N5613H-2018-08-18.md): Infinity CLASSIC 582 · S/N IPP2-102 · Cancelled Aug 18, 2018 · Sale reported, canceled · Built 2002
- [N8856D](https://openairdocs.org/deregistered/N8856D-2018-05-21.md): Piper PA-22-160 · S/N 22-6027 · Cancelled May 21, 2018 · Revoked, canceled · Built 1958 · Rygiel Jerome A
- [N37454](https://openairdocs.org/deregistered/N37454-2017-06-19.md): Balloon Works FIREFLY 7-B · S/N F7B-095 · Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1983 · Anderson Dennis L
- [N515HA](https://openairdocs.org/deregistered/N515HA-2017-02-01.md): DJI PHANTOM 2 VISION + · S/N PH645419876 · Cancelled Feb 1, 2017 · Hunziker And Associates Inc
- [N89CJ](https://openairdocs.org/deregistered/N89CJ-2016-12-08.md): Rosner Frank A ACRO SPORT II · S/N 197 · Cancelled Dec 8, 2016 · Second renewal notice · Built 1990 · Triplett James E
- [N5192M](https://openairdocs.org/deregistered/N5192M-2013-10-29.md): Petrone W R SELF DESIGNED · S/N W R P 15 · Cancelled Oct 29, 2013 · Registration expired, pending cancellation · Petrone William R
- [N54687](https://openairdocs.org/deregistered/N54687-2013-08-15.md): Raven S55A · S/N S55A-176 · Cancelled Aug 15, 2013 · Registration expired, pending cancellation · Built 1974 · Hot Air Inc
- [N27Z](https://openairdocs.org/deregistered/N27Z-2013-08-08.md): Smith MINIPLANE · S/N FAE-3 · Cancelled Aug 8, 2013 · Registration expired, pending cancellation · Built 1962 · Benda Michael L
- [N5245M](https://openairdocs.org/deregistered/N5245M-2012-12-11.md): Taylorcraft BC12-D · S/N 10545 · Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1947
- [N3608Q](https://openairdocs.org/deregistered/N3608Q-2012-10-09.md): Beech A23-24 · S/N MA-208 · Cancelled Oct 9, 2012 · Registration expired, pending cancellation · Built 1967 · Fullhart Charles B
- [N519S](https://openairdocs.org/deregistered/N519S-2012-08-13.md): Sawyer JEANIES TEENIE 1 · S/N HS-1 · Cancelled Aug 13, 2012 · Revoked, canceled · Built 1970 · Irish Richard M
- [N99930](https://openairdocs.org/deregistered/N99930-2012-06-14.md): Cessna 172P · S/N 17276528 · Cancelled Jun 14, 2012 · Second renewal notice · Built 1986 · Hap'S Air Inc
- [N4501M](https://openairdocs.org/deregistered/N4501M-2011-10-17.md): Piper PA-11 · S/N 11-5 · Cancelled Oct 17, 2011 · Revoked, pending cancellation · Built 1947 · Hawkeye Dusting Svc
- [N4730S](https://openairdocs.org/deregistered/N4730S-2011-06-17.md): Cessna TR182 · S/N R18201404 · Cancelled Jun 17, 2011 · Exported to Australia · Built 1979 · Barringer Jack
- [N1989R](https://openairdocs.org/deregistered/N1989R-2009-09-18.md): Raven S-50A · S/N S50A-196 · Cancelled Sep 18, 2009 · Registration revoked · Built 1972 · Scharff Floyd E
- [N500KL](https://openairdocs.org/deregistered/N500KL-2004-08-03.md): Lidman J Kirby BD 5 · S/N 892 · Cancelled Aug 3, 2004 · Triennial form not returned · Lidman J Kirby
- [N758AW](https://openairdocs.org/deregistered/N758AW-2004-03-18.md): Cessna R172K · S/N R1722950 · Cancelled Mar 18, 2004 · Exported to Philippines · Built 1978 · Wass Kim J
- [N96Y](https://openairdocs.org/deregistered/N96Y-2001-02-02.md): Esslstyn BRYAN AIRCRAFT RS-15 · S/N 16 · Cancelled Feb 2, 2001 · Triennial form not returned · Triad Group Of Silent Knights Inc
- [N6084Z](https://openairdocs.org/deregistered/N6084Z-1997-01-17.md): Piper PA-25 · S/N 2596 · Cancelled Jan 17, 1997 · Triennial form not returned · Silent Knights Inc
- [N2MZ](https://openairdocs.org/deregistered/N2MZ-1995-08-23.md): Tout William R GLASAIR · S/N 542R · Cancelled Aug 23, 1995 · Second triennial mailing, no response · Tout William R
- [N5048Q](https://openairdocs.org/deregistered/N5048Q-1995-01-31.md): Cessna 310N · S/N 310N0148 · Cancelled Jan 31, 1995 · Triennial form not returned · Fawcett Kennedy C
- [N3711M](https://openairdocs.org/deregistered/N3711M-1992-03-16.md): Cessna 172M · S/N 17267307 · Cancelled Mar 16, 1992 · Triennial form not returned · Ellis Charles J
- [N8222G](https://openairdocs.org/deregistered/N8222G-1991-09-11.md): Cessna 177RG · S/N 177RG0122 · Cancelled Sep 11, 1991 · Triennial form not returned · Four Cardinals Inc
- [N69026](https://openairdocs.org/deregistered/N69026-1985-05-15.md): Cessna 152 · S/N 15282444 · Cancelled May 15, 1985 · Haps Air Service
- [N2231S](https://openairdocs.org/deregistered/N2231S-1977-11-02.md): Cessna T210L · S/N 21061176 · Cancelled Nov 2, 1977 · Haps Air Service Inc
- [N2529R](https://openairdocs.org/deregistered/N2529R-1975-04-22.md): Cessna 182 · S/N 18258229 · Cancelled Apr 22, 1975 · Exported to Canada · Goodrich Aviation Inc
- [N4054U](https://openairdocs.org/deregistered/N4054U-1972-04-27.md): Cessna 150E · S/N 15061454 · Cancelled Apr 27, 1972 · Stevermer Emmett J
- [N77075](https://openairdocs.org/deregistered/N77075-1971-02-08.md): Cessna 140 · S/N 11529 · Cancelled Feb 8, 1971 · Built 1946 · Triplett James E Etal
- [N3667G](https://openairdocs.org/deregistered/N3667G-1970-06-22.md): Beech C-45H · S/N 52-10577 · Cancelled Jun 22, 1970 · Iowa State University
- [N4106N](https://openairdocs.org/deregistered/N4106N-1965-05-22.md): Cessna 140 · S/N 13564 · Cancelled May 22, 1965 · Howard Flying Service Inc
- [N9502A](https://openairdocs.org/deregistered/N9502A-1965-05-20.md): Cessna 170A · S/N 19063 · Cancelled May 20, 1965 · Miller George B Jr
- [N8523A](https://openairdocs.org/deregistered/N8523A-1957-12-12.md): Beech A35 · S/N D-1945 · Cancelled Dec 12, 1957 · Howard Flying Service Inc
- [N6565M](https://openairdocs.org/deregistered/N6565M-1957-10-01.md): Stinson 108-3 · S/N 108-4565 · Cancelled Oct 1, 1957 · Exported to Canada · Built 1948 · Leland Plumbing & Heating Co
- [N5514H](https://openairdocs.org/deregistered/N5514H-1953-07-22.md): Piper PA-11 · S/N 11-1016 · Cancelled Jul 22, 1953 · Hawkeye Spraying Service
- [N2706V](https://openairdocs.org/deregistered/N2706V-1952-03-26.md): Beech 35 · S/N D-82 · Cancelled Mar 26, 1952 · Howard Flying Service Inc
- [N37035](https://openairdocs.org/deregistered/N37035-1951-10-17.md): Luscombe 8C · S/N 1696 · Cancelled Oct 17, 1951 · Built 1941 · College Aero Club Inc

Next page: https://openairdocs.org/faa-place/IA/Ames/earlier.md?page=2

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

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