# Cancelled registrations: Hartselle, AL

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

Cancelled aircraft registrations in Hartselle, AL.

- [N94511](https://openairdocs.org/deregistered/N94511-2024-09-07.md): Benson Allen FERGY F-IIB · S/N 0002 · Cancelled Sep 7, 2024 · Sale reported, canceled · Built 2001
- [N205HH](https://openairdocs.org/deregistered/N205HH-2021-04-03.md): Buckeye Powered Parachutes DREAM MACHINE · S/N 4259 · Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1995 · Simmons Robert E
- [N2556Z](https://openairdocs.org/deregistered/N2556Z-2019-02-28.md): Piper PA-23-250 · S/N 27-8054048 · Cancelled Feb 28, 2019 · Registration expired, pending cancellation · Built 1980 · Blackstone Rotorcraft Inc
- [N6307Z](https://openairdocs.org/deregistered/N6307Z-2018-09-17.md): Piper PA-25 · S/N 25-391 · Cancelled Sep 17, 2018 · Built 1960 · Blackstone Aircraft LLC
- [N8107](https://openairdocs.org/deregistered/N8107-2018-05-31.md): Gardner-Roe FALCOMAR F-9 · S/N F4055 · Cancelled May 31, 2018 · Sale reported, canceled · Built 1973
- [N39RV](https://openairdocs.org/deregistered/N39RV-2018-01-04.md): Vinzant Roy ROTORWAY EXECUTIVE · S/N 12350 · Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1994 · Vinzant Roy H
- [N6572K](https://openairdocs.org/deregistered/N6572K-2013-10-28.md): Spivey Franklin G B8M · S/N S-223 · Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Spivey Franklin G
- [N487GN](https://openairdocs.org/deregistered/N487GN-2013-06-11.md): Bell 47D1 · S/N 487 · Cancelled Jun 11, 2013 · Registration expired, pending cancellation · Built 1952 · Newman Gene Jr
- [N71RF](https://openairdocs.org/deregistered/N71RF-2013-05-08.md): Froberg Ronald D ROTORWAY EXECUTIVE · S/N 1092 · Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1992 · Froberg Ronald P
- [N60622](https://openairdocs.org/deregistered/N60622-2013-05-01.md): Titan TORNADO II · S/N D97503SOHK0249 · Cancelled May 1, 2013 · Registration expired, pending cancellation · Built 1997 · Burcham Gregory S
- [N72GR](https://openairdocs.org/deregistered/N72GR-2008-02-14.md): Russel Glyn D RUSSELL-FALCO · S/N 1167 · Cancelled Feb 14, 2008 · Exported to Denmark · Built 1999 · Russell Glyn D
- [N4319P](https://openairdocs.org/deregistered/N4319P-2007-11-21.md): Piper PA-23-160 · S/N 23-1820 · Cancelled Nov 21, 2007 · Triennial form not returned · Built 1959 · Blackstone Rotorcraft Inc
- [N2496W](https://openairdocs.org/deregistered/N2496W-1997-10-31.md): Schweizer SGS 2-33 · S/N 41 · Cancelled Oct 31, 1997 · Triennial form not returned · Hall Charles W
- [N313H](https://openairdocs.org/deregistered/N313H-1994-07-21.md): Hall Charles W SONERAI LS-II · S/N 17A · Cancelled Jul 21, 1994 · Triennial form not returned · Hall Charles W
- [N4218Y](https://openairdocs.org/deregistered/N4218Y-1991-01-30.md): Hall-Spivey MITCHELL U-2 · S/N PJ484 · Cancelled Jan 30, 1991 · Triennial form not returned · Hall Charles W
- [N24843](https://openairdocs.org/deregistered/N24843-1948-09-24.md): Piper J3F-50 · S/N 3485 · Cancelled Sep 24, 1948 · Orr Leon Etal

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

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