# Cancelled registrations: Roanoke Rapids, NC

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

Cancelled aircraft registrations in Roanoke Rapids, NC.

- [N7154U](https://openairdocs.org/deregistered/N7154U-2023-09-06.md): Mooney M20E · S/N 393 · Cancelled Sep 6, 2023 · Built 1964 · Walls Of Time Inc
- [N3391M](https://openairdocs.org/deregistered/N3391M-2019-02-19.md): Piper PA-12 · S/N 12-2234 · Cancelled Feb 19, 2019 · Revoked, canceled · Built 1947 · Crisco William H
- [N93X](https://openairdocs.org/deregistered/N93X-2018-01-10.md): Boeing A75N1(PT17) · S/N 75-4351 · Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1942 · Foley Arthur J
- [N89920](https://openairdocs.org/deregistered/N89920-2017-11-21.md): Cessna 140 · S/N 8969 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Paul John
- [N6716E](https://openairdocs.org/deregistered/N6716E-2013-02-13.md): Cessna 175 · S/N 56216 · Cancelled Feb 13, 2013 · Sale reported, canceled · Built 1959
- [N418A](https://openairdocs.org/deregistered/N418A-2002-08-29.md): Sikorsky S-55C · S/N 55482 · Cancelled Aug 29, 2002 · Second triennial mailing, no response · Built 1954 · Rogers Dennis W
- [N8024T](https://openairdocs.org/deregistered/N8024T-1996-04-27.md): Cessna 182A · S/N 34239 · Cancelled Apr 27, 1996 · Triennial form not returned · Long Cotton Warehouse Inc
- [N3434Z](https://openairdocs.org/deregistered/N3434Z-1981-01-20.md): Piper PA-22-150 · S/N 22-7349 · Cancelled Jan 20, 1981 · Hazelwood William L Jr
- [N5917A](https://openairdocs.org/deregistered/N5917A-1976-10-12.md): Cessna 172 · S/N 28517 · Cancelled Oct 12, 1976 · Action Air Inc
- [N5121R](https://openairdocs.org/deregistered/N5121R-1976-08-10.md): Cessna 172M · S/N 17263339 · Cancelled Aug 10, 1976 · Exported to Dominican Republic · Built 1974 · Pittman James A DBA Coastal Supply Company
- [N92552](https://openairdocs.org/deregistered/N92552-1972-11-15.md): Piper PA-12 · S/N 12-81 · Cancelled Nov 15, 1972 · W J Long Jr
- [N23903](https://openairdocs.org/deregistered/N23903-1971-09-28.md): Aeronca 65-LA · S/N L5629 · Cancelled Sep 28, 1971 · Built 1939 · Jenkins James B
- [N3476V](https://openairdocs.org/deregistered/N3476V-1971-01-15.md): Cessna 195 · S/N 7176 · Cancelled Jan 15, 1971 · Luter III Paul Clarence
- [N6102W](https://openairdocs.org/deregistered/N6102W-1968-01-26.md): Piper PA-28-140 · S/N 28-20116 · Cancelled Jan 26, 1968 · Copenhaver W B
- [N99382](https://openairdocs.org/deregistered/N99382-1960-05-21.md): Ercoupe 415-C · S/N 2005 · Cancelled May 21, 1960 · Built 1946 · Barnett James
- [N93623](https://openairdocs.org/deregistered/N93623-1955-10-17.md): Ercoupe 415-C · S/N 946 · Cancelled Oct 17, 1955 · Built 1946 · Downing John R
- [N2358H](https://openairdocs.org/deregistered/N2358H-1952-09-16.md): Engineering & Research ERCOUPE 415-C · S/N 2983 · Cancelled Sep 16, 1952 · Built 1946 · Downing John R

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

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