# Cancelled registrations: Huntington, IN

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

Cancelled aircraft registrations in Huntington, IN.

- [N321DJ](https://openairdocs.org/deregistered/N321DJ-2023-02-04.md): Jones David L XP503 · S/N DR-0321 · Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Hendryx William H
- [N271AP](https://openairdocs.org/deregistered/N271AP-2019-02-05.md): Shooting Star LOCKHEED T-33A · S/N 01-51-4271A · Cancelled Feb 5, 2019 · Registration expired, pending cancellation · City Of Huntington
- [N17686](https://openairdocs.org/deregistered/N17686-2018-01-11.md): American Eaglecraft EAGLET A-31-1B · S/N 1201 · Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1940 · Hanson Daniel J
- [N8576D](https://openairdocs.org/deregistered/N8576D-2017-11-21.md): Piper PA-18 · S/N 18-6234 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1957 · Scott Hersil E
- [N4508S](https://openairdocs.org/deregistered/N4508S-2012-11-06.md): Cameron Balloons US C-80 · S/N 6303 · Cancelled Nov 6, 2012 · Built 2002 · Smart Christopher T
- [N61617](https://openairdocs.org/deregistered/N61617-2003-10-25.md): Cameron Balloons US C-80 · S/N 6020 · Cancelled Oct 25, 2003 · Triennial form not returned · Built 1996 · Smart Christopher T
- [N4058G](https://openairdocs.org/deregistered/N4058G-1999-10-28.md): Raven S55A · S/N S55A-862 · Cancelled Oct 28, 1999 · Triennial form not returned · Fawn Buck Inc
- [N8091N](https://openairdocs.org/deregistered/N8091N-1977-09-16.md): Piper PA-28-140 · S/N 28-25334 · Cancelled Sep 16, 1977 · Huntington Aviation Inc
- [N2SF](https://openairdocs.org/deregistered/N2SF-1975-10-29.md): Frank SMYTH SIDEWINDER · S/N 212207 · Cancelled Oct 29, 1975 · Frank Stephen F
- [N22AJ](https://openairdocs.org/deregistered/N22AJ-1974-12-20.md): Sutton SMYTH SIDEWINDER · S/N 212206 · Cancelled Dec 20, 1974 · Built 1974 · Sutton Andrews J
- [N8659N](https://openairdocs.org/deregistered/N8659N-1974-06-10.md): Piper PA-32-300 · S/N 32-7240006 · Cancelled Jun 10, 1974 · Exported to Australia · Howenstine Douglas
- [N4199E](https://openairdocs.org/deregistered/N4199E-1974-01-15.md): Aeronca 7AC · S/N 7AC-7144 · Cancelled Jan 15, 1974 · Built 1947 · Bowlin George
- [N173T](https://openairdocs.org/deregistered/N173T-1957-04-03.md): Piper PA-18-105 SPECIAL · S/N 18-2287 · Cancelled Apr 3, 1957 · Exported to Canada · Built 1953 · Snider Margaret L
- [N17180](https://openairdocs.org/deregistered/N17180-1956-02-20.md): Stinson SR-9C · S/N 5168 · Cancelled Feb 20, 1956 · Built 1937 · Schacht C A
- [N16551](https://openairdocs.org/deregistered/N16551-1948-04-16.md): Aeronca C-3 · S/N A-691 · Cancelled Apr 16, 1948 · Dearing William Harry
- [N14Y](https://openairdocs.org/deregistered/N14Y-1947-03-19.md): Hosler HOSLER B · S/N 2 · Cancelled Mar 19, 1947 · Hosler Russell

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

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