# Cancelled registrations: Rocky Mount, NC

A list on [Rocky Mount, NC](https://openairdocs.org/faa-place/NC/Rocky%20Mount.md).

Cancelled aircraft registrations in Rocky Mount, NC.

- [N38744](https://openairdocs.org/deregistered/N38744-2020-01-24.md): Piper J3F-65 · S/N 7221 · Cancelled Jan 24, 2020 · Revoked, canceled · Built 1941 · Rocky Mount Dust & Spray Co Inc
- [N22007](https://openairdocs.org/deregistered/N22007-2019-10-25.md): Luscombe 8 · S/N 857 · Cancelled Oct 25, 2019 · Revoked, canceled · Built 1938 · Avalon Air Svc
- [N87735](https://openairdocs.org/deregistered/N87735-2019-09-06.md): Piper J3C-65 · S/N 15394 · Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Rocky Mount Air Svc Inc
- [N4143M](https://openairdocs.org/deregistered/N4143M-2018-04-05.md): Piper PA-12 · S/N 123042 · Cancelled Apr 5, 2018 · Revoked, canceled · Built 1947 · Broadfield Frances T
- [N6043H](https://openairdocs.org/deregistered/N6043H-2017-11-21.md): Piper J3C-65 · S/N 19188 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Outlaw Virgil Lee
- [N6506P](https://openairdocs.org/deregistered/N6506P-2017-04-04.md): Powrachute PC 2000 · S/N A219 POW · Cancelled Apr 4, 2017 · Registration expired, pending cancellation · Built 2000 · Pickering Charles H
- [N85296](https://openairdocs.org/deregistered/N85296-2017-02-04.md): Aeronca 7AC · S/N 7AC4034 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Rocky Mount Air Svc Inc
- [N5027Z](https://openairdocs.org/deregistered/N5027Z-2013-03-21.md): Piper PA-22-108 · S/N 22-8642 · Cancelled Mar 21, 2013 · Registration expired, pending cancellation · Built 1961 · Urquhart Lewis T
- [N7931R](https://openairdocs.org/deregistered/N7931R-2013-02-27.md): Beech V35A · S/N D-8953 · Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1969
- [N17941](https://openairdocs.org/deregistered/N17941-2012-08-13.md): Schweizer SGS 2-33A · S/N 293 · Cancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1973 · Stahl Lawrence E
- [N808GM](https://openairdocs.org/deregistered/N808GM-2011-11-04.md): Cessna 182T · S/N 18282076 · Cancelled Nov 4, 2011 · Exported to Australia · Built 2008 · Air Care Inc
- [N2940M](https://openairdocs.org/deregistered/N2940M-2009-07-24.md): Piper PA-12 · S/N 12-1339 · Cancelled Jul 24, 2009 · Registration revoked · Built 1946 · Rocky Mount Air Service Inc
- [N2489W](https://openairdocs.org/deregistered/N2489W-2009-07-14.md): Schweizer SGS 2-33 · S/N 42 · Cancelled Jul 14, 2009 · Registration revoked · Built 1967 · Stahl Lawrence E
- [N1251C](https://openairdocs.org/deregistered/N1251C-2009-07-07.md): Cessna T182T · S/N T18208407 · Cancelled Jul 7, 2009 · Exported to Canada · Built 2005
- [N7716V](https://openairdocs.org/deregistered/N7716V-2004-01-15.md): Aero Commander CALLAIR A-9 · S/N 1468 · Cancelled Jan 15, 2004 · Triennial form undeliverable · Built 1969 · Rocky Mount Aerial Applicators Inc
- [N74LV](https://openairdocs.org/deregistered/N74LV-1994-02-09.md): Beech B200 · S/N BB1074 · Cancelled Feb 9, 1994 · Triennial form not returned · Franchise Enterprises Inc
- [N316MH](https://openairdocs.org/deregistered/N316MH-1992-10-27.md): Cessna 421B · S/N 421B0327 · Cancelled Oct 27, 1992 · Triennial form not returned · Texfi Industries Inc
- [N44AC](https://openairdocs.org/deregistered/N44AC-1982-11-05.md): Piper PA-23-250 · S/N 27-2674 · Cancelled Nov 5, 1982 · Air Care Inc
- [N9310T](https://openairdocs.org/deregistered/N9310T-1982-09-23.md): Piper PA-38-112 · S/N 38-78A0020 · Cancelled Sep 23, 1982 · Administratively canceled · Air Care Inc
- [N9794P](https://openairdocs.org/deregistered/N9794P-1980-04-04.md): Piper PA-25-235 · S/N 25-7556107 · Cancelled Apr 4, 1980 · Exported to Canada · Air Care Inc
- [N9165T](https://openairdocs.org/deregistered/N9165T-1979-04-12.md): Piper PA-25-235 · S/N 25-7856017 · Cancelled Apr 12, 1979 · Exported to Turkey · Air Care Inc
- [N6687Q](https://openairdocs.org/deregistered/N6687Q-1978-05-01.md): Schweizer G-164B · S/N 204B · Cancelled May 1, 1978 · Exported to United Kingdom · Built 1977 · Air Care Inc
- [N70158](https://openairdocs.org/deregistered/N70158-1977-09-16.md): Cessna A188B · S/N 18801852T · Cancelled Sep 16, 1977 · Exported to Australia · Air Care Inc
- [N54927](https://openairdocs.org/deregistered/N54927-1977-05-03.md): Piper PA-25-235 · S/N 257656066 · Cancelled May 3, 1977 · Exported to United Kingdom · Air Care Inc
- [N54976](https://openairdocs.org/deregistered/N54976-1977-03-09.md): Piper PA-18-150 · S/N 187709028 · Cancelled Mar 9, 1977 · Exported to United Kingdom · Air Care Inc
- [N54893](https://openairdocs.org/deregistered/N54893-1977-02-25.md): Piper PA-25-235 · S/N 257656038 · Cancelled Feb 25, 1977 · Exported to United Kingdom · Air Care Inc
- [N82336](https://openairdocs.org/deregistered/N82336-1976-12-30.md): Piper PA-25-235 · S/N 25-7656083 · Cancelled Dec 30, 1976 · Exported to United Kingdom · Built 1976 · Air Care Inc
- [N82341](https://openairdocs.org/deregistered/N82341-1976-12-30.md): Piper PA-25-235 · S/N 25-7656088 · Cancelled Dec 30, 1976 · Exported to United Kingdom · Built 1976 · Air Care Inc
- [N54918](https://openairdocs.org/deregistered/N54918-1976-11-03.md): Piper PA-25-235 · S/N 257656059 · Cancelled Nov 3, 1976 · Exported to United Kingdom · Air Care Inc
- [N54926](https://openairdocs.org/deregistered/N54926-1976-11-03.md): Piper PA-25-235 · S/N 257656065 · Cancelled Nov 3, 1976 · Exported to United Kingdom · Air Care Inc
- [N21627](https://openairdocs.org/deregistered/N21627-1976-05-17.md): Cessna A188B · S/N 18800918 · Cancelled May 17, 1976 · Air-Care Inc
- [N44092](https://openairdocs.org/deregistered/N44092-1976-05-11.md): Piper PA-28-151 · S/N 28-7415579 · Cancelled May 11, 1976 · Exported to Canada · Built 1974 · Air Care Inc
- [N7472L](https://openairdocs.org/deregistered/N7472L-1975-07-31.md): Piper PA-18-150 · S/N 18-7509068 · Cancelled Jul 31, 1975 · Exported to Canada · Air Care Inc
- [N8409V](https://openairdocs.org/deregistered/N8409V-1973-05-24.md): Aero Commander 560-A · S/N 1609 · Cancelled May 24, 1973 · Air Ag Inc
- [N9486K](https://openairdocs.org/deregistered/N9486K-1965-05-20.md): Stinson 108-2 · S/N 108-2486 · Cancelled May 20, 1965 · Starling Leonard B Jr
- [N82676](https://openairdocs.org/deregistered/N82676-1964-06-24.md): Aeronca 7AC · S/N 7AC-1319 · Cancelled Jun 24, 1964 · Broadfield Frances T
- [N2150M](https://openairdocs.org/deregistered/N2150M-1956-02-29.md): Piper J3C-65 · S/N 20935 · Cancelled Feb 29, 1956 · Frank R Hall
- [N98199](https://openairdocs.org/deregistered/N98199-1956-02-27.md): Piper J3C-65 · S/N 18359 · Cancelled Feb 27, 1956 · Rocky Mount Air Service
- [N97308](https://openairdocs.org/deregistered/N97308-1955-08-03.md): Stinson 108 · S/N 108-308 · Cancelled Aug 3, 1955 · Built 1946 · Rocky Mount Air Service
- [N92240](https://openairdocs.org/deregistered/N92240-1955-02-07.md): Piper J3C-65 · S/N 16685 · Cancelled Feb 7, 1955 · Broadfield Frances T
- [N92190](https://openairdocs.org/deregistered/N92190-1954-08-16.md): Piper J-3 · S/N 16630 · Cancelled Aug 16, 1954 · Breadfield Frances T
- [N70774](https://openairdocs.org/deregistered/N70774-1952-10-03.md): Piper J3C-65 · S/N 17795 · Cancelled Oct 3, 1952 · Rocky Mount Air Service
- [N4016M](https://openairdocs.org/deregistered/N4016M-1950-06-07.md): Piper PA-12 · S/N 12-2894 · Cancelled Jun 7, 1950 · Rocky Mount Air Service
- [N5219](https://openairdocs.org/deregistered/N5219-1948-03-12.md): Ryan B1 · S/N 107 · Cancelled Mar 12, 1948 · Lee Robert Edward
- [N67Y](https://openairdocs.org/deregistered/N67Y-1938-06-01.md): Brodgen Ralph G FLYING FLEA · S/N 1-B · Cancelled Jun 1, 1938 · Brodgen Ralph G
- [N7480](https://openairdocs.org/deregistered/N7480-1934-08-31.md): Standard J-1 · S/N 222 · Cancelled Aug 31, 1934 · Williams C G
- [N1831](https://openairdocs.org/deregistered/N1831-1933-02-03.md): American Eagle A-1 · S/N 59 · Cancelled Feb 3, 1933 · Built 1927 · Byrd John Franklin

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

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