# Cancelled registrations: Crystal River, FL

A list on [Crystal River, FL](https://openairdocs.org/faa-place/FL/Crystal%20River.md).

Cancelled aircraft registrations in Crystal River, FL.

- [N619J](https://openairdocs.org/deregistered/N619J-2023-02-07.md): Jabiru USA Sport J250-SP · S/N 457 · Cancelled Feb 7, 2023 · Third renewal notice · Smoak T F
- [N318CD](https://openairdocs.org/deregistered/N318CD-2022-09-03.md): Polaris FIB 582 · S/N 0331077 · Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Built 2007 · Strock Kenneth E Jr
- [N1563X](https://openairdocs.org/deregistered/N1563X-2019-08-09.md): Piper PA-32-260 · S/N 32-7500037 · Cancelled Aug 9, 2019 · First renewal notice · Built 1975 · Palmer Anna M
- [N9226V](https://openairdocs.org/deregistered/N9226V-2018-06-08.md): Mooney M20C · S/N 690054 · Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Built 1969 · Schlumberger Accounting Service Inc
- [N618RG](https://openairdocs.org/deregistered/N618RG-2018-01-25.md): Gerhardt Russell A DOMINATOR GYRO PLANE · S/N GERDOM001 · Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1999 · Gerhardt Russell A
- [N2678R](https://openairdocs.org/deregistered/N2678R-2017-07-20.md): Flightstar II SC · S/N FS251 · Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 2005 · Roberts Geoffrey
- [N2677R](https://openairdocs.org/deregistered/N2677R-2017-07-18.md): Phantom X-1 · S/N PA251 · Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 2007 · Roberts Geoffrey
- [N41964](https://openairdocs.org/deregistered/N41964-2017-07-14.md): Eiland Marvin T SPARROWHAWK · S/N H20030008K · Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 2004 · American Autogyro Of Crystal River Fl LLC
- [N466FL](https://openairdocs.org/deregistered/N466FL-2017-06-14.md): Piper PA-28-140 · S/N 28-7125266 · Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1971 · Pratt J Robert
- [N48040](https://openairdocs.org/deregistered/N48040-2017-02-24.md): Let BLANIK L-13 · S/N 026118 · Cancelled Feb 24, 2017 · First renewal notice · Built 1974 · Crystal Aero Group Inc
- [N115JS](https://openairdocs.org/deregistered/N115JS-2013-04-09.md): Strutt John A VARIEZE · S/N 2193 · Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Strutt John A
- [N60980](https://openairdocs.org/deregistered/N60980-2012-08-21.md): Ultravia Aero Intl PELICAN CLUB PL · S/N 661 · Cancelled Aug 21, 2012 · Registration pending, canceled · Built 1998
- [N592PR](https://openairdocs.org/deregistered/N592PR-2010-10-13.md): Piper PA-32-260 · S/N 32-289 · Cancelled Oct 13, 2010 · Triennial form not returned · Built 1966 · Taylor Gregory S
- [N9912X](https://openairdocs.org/deregistered/N9912X-2010-03-25.md): Smith Thomas A VANS RV-9 · S/N 91318 · Cancelled Mar 25, 2010 · Exported to Netherlands · Built 2007 · Smith Thomas A
- [N2631](https://openairdocs.org/deregistered/N2631-2009-10-14.md): Beech C18S · S/N 7820 · Cancelled Oct 14, 2009 · Registration revoked · Built 1944 · Roth Inc
- [N5811M](https://openairdocs.org/deregistered/N5811M-2008-08-08.md): Cessna 310P · S/N 310P0111 · Cancelled Aug 8, 2008 · Triennial form not returned · Built 1969 · Crystal Aero Group Inc
- [N67VA](https://openairdocs.org/deregistered/N67VA-2005-01-05.md): Allred Kenneth L SR DER KRICKET DK-1 · S/N 067 · Cancelled Jan 5, 2005 · Triennial form not returned · Built 1984 · Santonastaso Michael W
- [N73829](https://openairdocs.org/deregistered/N73829-2001-11-29.md): Cessna 172N · S/N 17267705 · Cancelled Nov 29, 2001 · Triennial form not returned · Built 1976 · Crystal Aero Group Inc
- [N8436C](https://openairdocs.org/deregistered/N8436C-2000-07-13.md): Piper PA-28-181 · S/N 28-7690140 · Cancelled Jul 13, 2000 · Triennial form not returned · Crystal Aero Group Inc
- [N787JG](https://openairdocs.org/deregistered/N787JG-1997-11-05.md): Guderian Barton D AVID FLYER · S/N 223 · Cancelled Nov 5, 1997 · Sale reported
- [N19264](https://openairdocs.org/deregistered/N19264-1996-07-12.md): Cessna 150L · S/N 15074285 · Cancelled Jul 12, 1996 · Triennial form not returned · Crystal Aero Group Inc
- [N5396Q](https://openairdocs.org/deregistered/N5396Q-1992-01-13.md): Cessna 150L · S/N 15073296 · Cancelled Jan 13, 1992 · Triennial form not returned · Crystal Aero Group Inc
- [N704SN](https://openairdocs.org/deregistered/N704SN-1991-06-29.md): Cessna 150M · S/N 15078839 · Cancelled Jun 29, 1991 · Crystal Aero Group Inc
- [N7597L](https://openairdocs.org/deregistered/N7597L-1986-03-26.md): Cessna A152 · S/N A1520822 · Cancelled Mar 26, 1986 · Surrency William W
- [N31141](https://openairdocs.org/deregistered/N31141-1979-12-21.md): Stewart BENSEN B-8M · S/N 1 · Cancelled Dec 21, 1979 · Stewart Thomas J/Stewart Daniel J
- [N490M](https://openairdocs.org/deregistered/N490M-1966-07-12.md): Mooney M-18C · S/N 243 · Cancelled Jul 12, 1966 · Arnold David A
- [N80847](https://openairdocs.org/deregistered/N80847-1965-05-22.md): Globe GC-1A · S/N 250 · Cancelled May 22, 1965 · Built 1946 · Bechtel Carroll S
- [N8115E](https://openairdocs.org/deregistered/N8115E-1965-05-21.md): Mooney M20A · S/N 1386 · Cancelled May 21, 1965 · Mcgowan Jack
- [N10530](https://openairdocs.org/deregistered/N10530-1960-01-21.md): North American AT-6D · S/N 121-42225 · Cancelled Jan 21, 1960 · Built 1957 · Mcgowan Jack
- [N72387](https://openairdocs.org/deregistered/N72387-1953-03-13.md): Cessna 140 · S/N 9573 · Cancelled Mar 13, 1953 · Crosby W E

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

This list as a web page: https://openairdocs.org/faa-place/FL/Crystal%20River/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.