# Cancelled registrations: Rolling Fork, MS

A list on [Rolling Fork, MS](https://openairdocs.org/faa-place/MS/Rolling%20Fork.md).

Cancelled aircraft registrations in Rolling Fork, MS.

- [N257LA](https://openairdocs.org/deregistered/N257LA-2013-02-13.md): Air Tractor AT-502B · S/N 502B-0257 · Cancelled Feb 13, 2013 · Second renewal notice · Built 1994 · Dewby Inc
- [N23543](https://openairdocs.org/deregistered/N23543-2013-01-18.md): Kilmury Murray A BENSON GYROCOPTER · S/N 102454 · Cancelled Jan 18, 2013 · Sale reported, pending cancellation
- [N9212R](https://openairdocs.org/deregistered/N9212R-2000-04-14.md): Cessna A188B · S/N 18802157T · Cancelled Apr 14, 2000 · Cummins Flying Service Inc
- [N2321V](https://openairdocs.org/deregistered/N2321V-1994-11-28.md): Air Tractor AT-301 · S/N 3010368 · Cancelled Nov 28, 1994 · Triennial form not returned · Nick'S Flying Service Inc
- [N23509](https://openairdocs.org/deregistered/N23509-1994-11-28.md): Air Tractor AT-301 · S/N 3010391 · Cancelled Nov 28, 1994 · Triennial form not returned · Nick'S Flying Service Inc
- [N70356](https://openairdocs.org/deregistered/N70356-1993-12-30.md): Cessna A188B · S/N 18801897T · Cancelled Dec 30, 1993 · Exported to Brazil · Denons Flying Service Inc
- [N766SP](https://openairdocs.org/deregistered/N766SP-1991-05-01.md): Harris Sam E LONGEZ · S/N 766 · Cancelled May 1, 1991 · Triennial form not returned · Harris Sam E
- [N9395G](https://openairdocs.org/deregistered/N9395G-1974-10-29.md): Cessna A188B · S/N 188-01473 · Cancelled Oct 29, 1974 · Nicks Flying Service Inc
- [N9020R](https://openairdocs.org/deregistered/N9020R-1974-09-24.md): Clark 1000 · S/N 1000-8 · Cancelled Sep 24, 1974 · Sharpe Odus J Jr
- [N84703](https://openairdocs.org/deregistered/N84703-1974-09-23.md): Aeronca 7AC · S/N 7AC-3415 · Cancelled Sep 23, 1974 · Built 1946 · Smith Joe & Sharpe Markus & Smith James E
- [N462Y](https://openairdocs.org/deregistered/N462Y-1974-09-18.md): Grumman G-164 · S/N 108 · Cancelled Sep 18, 1974 · South Delta Aviation
- [N33034](https://openairdocs.org/deregistered/N33034-1974-07-26.md): Piper J3C-65 · S/N 5791 · Cancelled Jul 26, 1974 · Built 1946 · House Nathaniel C Jr
- [N5820E](https://openairdocs.org/deregistered/N5820E-1974-07-25.md): Cessna 150 · S/N 17320 · Cancelled Jul 25, 1974 · Grant Jerry R
- [N4441Y](https://openairdocs.org/deregistered/N4441Y-1970-09-23.md): Piper PA-25-235 · S/N 25-4075 · Cancelled Sep 23, 1970 · Small Flying Service
- [N52286](https://openairdocs.org/deregistered/N52286-1970-07-30.md): Boeing A75N1 · S/N 75-1419 · Cancelled Jul 30, 1970 · Built 1941 · Rodgers W R
- [N554T](https://openairdocs.org/deregistered/N554T-1970-07-30.md): North American F-51D · S/N 4473458A · Cancelled Jul 30, 1970 · Rodgers W R
- [N44870](https://openairdocs.org/deregistered/N44870-1965-06-03.md): Naval Aircraft Factory N3N-3 · S/N 2776 · Cancelled Jun 3, 1965 · South Delta Aviation Inc
- [N45196](https://openairdocs.org/deregistered/N45196-1965-05-20.md): Naval Aircraft Factory N3N-3 · S/N 27666 · Cancelled May 20, 1965 · South Delta Aviation Inc
- [N78624](https://openairdocs.org/deregistered/N78624-1962-03-15.md): Piper PA-11 · S/N 11-1385 · Cancelled Mar 15, 1962 · Exported to Canada · Built 1947 · Lovorn H G
- [N3350N](https://openairdocs.org/deregistered/N3350N-1956-08-06.md): Piper J-3 · S/N 22549 · Cancelled Aug 6, 1956 · Lovern H G
- [N24143](https://openairdocs.org/deregistered/N24143-1952-03-18.md): Funk B75L · S/N 69 · Cancelled Mar 18, 1952 · Built 1940 · Graft Bogard

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

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