# Cancelled registrations: Columbia City, IN

A list on [Columbia City, IN](https://openairdocs.org/faa-place/IN/Columbia%20City.md).

Cancelled aircraft registrations in Columbia City, IN.

- [N5365V](https://openairdocs.org/deregistered/N5365V-2024-01-16.md): Crownover Mark F-1 FERGY · S/N 1001 · Cancelled Jan 16, 2024 · Sale reported, canceled · Built 1995
- [N627CA](https://openairdocs.org/deregistered/N627CA-2022-12-31.md): Centrair 101A · S/N 101A0189 · Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 1984 · Houser Mark W
- [N760BS](https://openairdocs.org/deregistered/N760BS-2019-10-05.md): DJI PHANTOM 3 PROFESSION · S/N P76DCG23A17523 · Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Sigler Ryan A
- [N663WR](https://openairdocs.org/deregistered/N663WR-2018-05-31.md): DJI PHANTOM 2 VISION + · S/N PH645249448 · Cancelled May 31, 2018 · Sale reported, canceled
- [N7811U](https://openairdocs.org/deregistered/N7811U-2014-03-03.md): Cessna 172E · S/N 17251811 · Cancelled Mar 3, 2014 · Built 1964 · Prezbindowski James F
- [N74918](https://openairdocs.org/deregistered/N74918-2013-04-18.md): Johnson Robert A TITAN TORNADO · S/N 96-173 · Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Johnson Robert A
- [N3894R](https://openairdocs.org/deregistered/N3894R-2012-01-09.md): Cessna 172H · S/N 17255394 · Cancelled Jan 9, 2012 · Sale reported · Built 1966
- [N94628](https://openairdocs.org/deregistered/N94628-2010-04-26.md): JDT Mini-Max V-MAX · S/N JDT-249 · Cancelled Apr 26, 2010 · Rex Bruce E
- [N7009Z](https://openairdocs.org/deregistered/N7009Z-2003-12-29.md): Rex Bruce E RANS S 9 EXP · S/N 0488050 · Cancelled Dec 29, 2003 · Built 1989 · Rex Bruce E
- [N23771](https://openairdocs.org/deregistered/N23771-2003-06-04.md): Jodel F-11 · S/N 1 · Cancelled Jun 4, 2003 · Triennial form not returned · Built 1972 · Adams Donald E
- [N29874](https://openairdocs.org/deregistered/N29874-2002-08-29.md): Taylorcraft BF12-65 · S/N 2725 · Cancelled Aug 29, 2002 · Triennial form not returned · Built 1941 · Adams Donald E
- [N699DT](https://openairdocs.org/deregistered/N699DT-1993-11-19.md): Cessna 421B · S/N 421B0540 · Cancelled Nov 19, 1993 · Five Star Aviation Co
- [N17A](https://openairdocs.org/deregistered/N17A-1976-05-14.md): Adams SIDEWINDER · S/N 212203 · Cancelled May 14, 1976 · Built 1973 · Adams Donald E
- [N5618P](https://openairdocs.org/deregistered/N5618P-1973-06-25.md): Piper PA-24-180 · S/N 24-686 · Cancelled Jun 25, 1973 · Sheehan James Lee
- [N34464](https://openairdocs.org/deregistered/N34464-1948-08-09.md): Aeronca 65-TL · S/N L9991T · Cancelled Aug 9, 1948 · Built 1941 · Sewell John F Et Al
- [N4479](https://openairdocs.org/deregistered/N4479-1931-10-30.md): Waco GXE · S/N 1323 · Cancelled Oct 30, 1931 · Magley Kenneth E & Merrill F Magley

## 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 = 'IN' AND d.registrant_city = 'COLUMBIA CITY'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/IN/Columbia%20City/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, except the copies of manufacturers’ service documents, which belong to their rights holders.