# Cancelled registrations: Clarinda, IA

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

Cancelled aircraft registrations in Clarinda, IA.

- [N5553X](https://openairdocs.org/deregistered/N5553X-2021-12-17.md): Aero Commander S2R · S/N 1753R · Cancelled Dec 17, 2021 · Sale reported, canceled · Built 1973
- [N700AH](https://openairdocs.org/deregistered/N700AH-2021-03-06.md): Arlan J Hoskins AVID MARK IV · S/N 1375D · Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Hoskins Arlan J
- [N8000S](https://openairdocs.org/deregistered/N8000S-2018-03-29.md): Cessna 150F · S/N 15061600 · Cancelled Mar 29, 2018 · Registration expired, pending cancellation · Built 1965 · Call One Inc
- [N121MH](https://openairdocs.org/deregistered/N121MH-2018-02-08.md): Call One DRAGONFLY · S/N 2965 · Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Call One Inc
- [N215BD](https://openairdocs.org/deregistered/N215BD-2017-09-18.md): Crain Jac A BD-4 · S/N 215 · Cancelled Sep 18, 2017 · Registration expired, pending cancellation · Built 2005 · Crain Construction Inc
- [N101TF](https://openairdocs.org/deregistered/N101TF-2013-07-02.md): Farrens Thomas WAR F4U CORSAIR · S/N 101 · Cancelled Jul 2, 2013 · Registration expired, pending cancellation · Built 2002 · Farrens Thomas
- [N181WC](https://openairdocs.org/deregistered/N181WC-2013-02-25.md): Piper PA-28-181 · S/N 28-8190124 · Cancelled Feb 25, 2013 · Sale reported, canceled
- [N21KU](https://openairdocs.org/deregistered/N21KU-2011-12-29.md): Mooney M20S · S/N 30-0032 · Cancelled Dec 29, 2011 · Exported to Canada · Built 1999 · Mosier Mark E
- [N781LM](https://openairdocs.org/deregistered/N781LM-2009-04-16.md): Beverly Louis H JR DRAGONFLY · S/N H-5167 · Cancelled Apr 16, 2009 · Call One Inc
- [N7972B](https://openairdocs.org/deregistered/N7972B-1976-11-24.md): Cessna 172 · S/N 29772 · Cancelled Nov 24, 1976 · Exported to Canada · Mier Glenn H
- [N2492L](https://openairdocs.org/deregistered/N2492L-1975-07-25.md): Cessna 172H · S/N 17255692 · Cancelled Jul 25, 1975 · Exported to Canada · Andrew Willard
- [N1762N](https://openairdocs.org/deregistered/N1762N-1974-08-07.md): Cessna 120 · S/N 12006 · Cancelled Aug 7, 1974 · Gordon L Meyer
- [N42475](https://openairdocs.org/deregistered/N42475-1974-07-26.md): Piper J3C-65 · S/N 14744 · Cancelled Jul 26, 1974 · Built 1945 · Stick And Rag Flying Club
- [N5469P](https://openairdocs.org/deregistered/N5469P-1973-02-23.md): Piper PA-24 · S/N 24-526 · Cancelled Feb 23, 1973 · Zehr Earl E
- [N76959](https://openairdocs.org/deregistered/N76959-1971-08-11.md): Cessna 140 · S/N 11405 · Cancelled Aug 11, 1971 · Exported to Canada · Andrew Flying Service
- [N2179R](https://openairdocs.org/deregistered/N2179R-1971-04-20.md): Cessna 182G · S/N 18255379 · Cancelled Apr 20, 1971 · Exported to Canada · Opitz Flying Service Inc
- [N6801B](https://openairdocs.org/deregistered/N6801B-1969-04-22.md): Piper PA-22-150 · S/N 22-4096 · Cancelled Apr 22, 1969 · Exported to Canada · Built 1956 · Tunnicliff Joe DBA
- [N78768](https://openairdocs.org/deregistered/N78768-1969-02-25.md): Piper PA-11 · S/N 11-1546 · Cancelled Feb 25, 1969 · Exported to Canada · Schenck Ray
- [N5351R](https://openairdocs.org/deregistered/N5351R-1968-12-30.md): Cessna 172F · S/N 17252880 · Cancelled Dec 30, 1968 · Exported to Canada · Tunnicliff Joe DBA Opitz Motor Co
- [N7035P](https://openairdocs.org/deregistered/N7035P-1967-09-27.md): Piper PA-24 · S/N 24-2182 · Cancelled Sep 27, 1967 · Exported to Canada · Tunnicliff Joe
- [N23536](https://openairdocs.org/deregistered/N23536-1965-05-21.md): Aeronca 65-C · S/N C-4819 · Cancelled May 21, 1965 · Built 1939 · Page County Flying Club
- [N4945M](https://openairdocs.org/deregistered/N4945M-1962-08-13-20-636.md): Piper PA-20 · S/N 20-636 · Cancelled Aug 13, 1962 · Exported to Canada · Opitz Motor Co
- [N41371](https://openairdocs.org/deregistered/N41371-1948-09-13.md): Piper J3L-65 · S/N 8028 · Cancelled Sep 13, 1948 · Built 1941 · Haxby Robert J/ Smith Cecil I
- [N1820V](https://openairdocs.org/deregistered/N1820V-1948-02-25.md): Cessna 120 · S/N 14005 · Cancelled Feb 25, 1948 · Schenck Ray
- [N94018](https://openairdocs.org/deregistered/N94018-1946-08-28.md): Engineering & Research ERCOUPE 415-C · S/N 1341 · Cancelled Aug 28, 1946 · Built 1946 · Smith Cecil I & Haxby Robert 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 = 'CLARINDA'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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