# Cancelled registrations: Warwick, RI

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

Cancelled aircraft registrations in Warwick, RI.

- [N785EX](https://openairdocs.org/deregistered/N785EX-2020-01-06.md): Xactsense MAX-8 · S/N XSMAX82004 · Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Xactsense Inc
- [N194RH](https://openairdocs.org/deregistered/N194RH-2019-05-04.md): Elevated Perspective Media S1000+ · S/N 33662F60867B91C8A8BFA8FB413 · Cancelled May 4, 2019 · Registration expired, pending cancellation · Elevated Perspective Media
- [N224TA](https://openairdocs.org/deregistered/N224TA-2019-04-22.md): Cessna 172S · S/N 172S9224 · Cancelled Apr 22, 2019 · Built 2002 · New Horizon Aviation Inc
- [N196RH](https://openairdocs.org/deregistered/N196RH-2019-02-23.md): Chris Walsh VULCAN RAVEN · S/N 6DD4D0C125022E44570AA5B9GE6622 · Cancelled Feb 23, 2019 · Registration expired, pending cancellation · Elevated Perspective Media
- [N500JW](https://openairdocs.org/deregistered/N500JW-2018-03-05.md): Gulfstream American G-1159 · S/N 234 · Cancelled Mar 5, 2018 · Registration expired, pending cancellation · Built 1978 · Jet-A-Way LLC
- [N3740A](https://openairdocs.org/deregistered/N3740A-2018-01-18.md): Quicksilver Eipper Acft GT 400 · S/N GT 2801051 · Cancelled Jan 18, 2018 · Registration expired, pending cancellation · Vespia Anthony J
- [N1189N](https://openairdocs.org/deregistered/N1189N-2018-01-10.md): Yakovlev YAK 52 · S/N 878208 · Cancelled Jan 10, 2018 · Registration expired, pending cancellation · Built 1987 · Carroll Karla
- [N1284U](https://openairdocs.org/deregistered/N1284U-2014-09-03.md): Aero Commander 680FL · S/N 1449-79 · Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1964 · New England Air Express Inc
- [N9845J](https://openairdocs.org/deregistered/N9845J-2013-05-30.md): Cessna 172N · S/N 17273931 · Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1980 · Spy In The Sky Operations Inc
- [N4829V](https://openairdocs.org/deregistered/N4829V-2013-03-18.md): Cessna 172RG · S/N 172RG0394 · Cancelled Mar 18, 2013 · Sale reported, pending cancellation · Built 1980
- [N203ND](https://openairdocs.org/deregistered/N203ND-2007-09-18.md): Diamond Aircraft Ind DA20-C1 · S/N C0012 · Cancelled Sep 18, 2007 · Exported to Germany · Built 1998 · New Horizon Aviation Inc
- [N5241B](https://openairdocs.org/deregistered/N5241B-1999-04-01.md): Cessna 152 · S/N 15283814 · Cancelled Apr 1, 1999 · Triennial form not returned · Corporate Air Charter Inc
- [N5452S](https://openairdocs.org/deregistered/N5452S-1993-10-14.md): Cessna R182 · S/N R18201573 · Cancelled Oct 14, 1993 · Exported to Canada · Lso Ventures Inc DBA
- [N47898](https://openairdocs.org/deregistered/N47898-1981-06-25.md): Piper PA-34-200T · S/N 34-7870013 · Cancelled Jun 25, 1981 · Exported to Canada · Built 1977 · M T Associates Inc
- [N67205](https://openairdocs.org/deregistered/N67205-1980-11-12.md): Bell TH-13T · S/N 3686 · Cancelled Nov 12, 1980 · State Of Rhode Island Dept Of Transportation
- [N42264](https://openairdocs.org/deregistered/N42264-1977-07-07.md): Cessna 182L · S/N 18259832 · Cancelled Jul 7, 1977 · Built 1968 · Boudrea Harold L
- [N6756G](https://openairdocs.org/deregistered/N6756G-1977-04-26.md): Cessna 150L · S/N 15072256 · Cancelled Apr 26, 1977 · Lippitt Aviation Inc
- [N35526](https://openairdocs.org/deregistered/N35526-1974-05-16.md): Cessna 172I · S/N 172-56814 · Cancelled May 16, 1974 · Built 1968 · Dole Aviation Inc
- [N23140](https://openairdocs.org/deregistered/N23140-1970-06-29.md): Cessna 150 · S/N 15068749 · Cancelled Jun 29, 1970 · Built 1968 · Newport Airpark Inc
- [N2607K](https://openairdocs.org/deregistered/N2607K-1965-05-21.md): Luscombe 8E · S/N 5334 · Cancelled May 21, 1965 · Lippitt Aviation Corp
- [N3558S](https://openairdocs.org/deregistered/N3558S-1965-05-20.md): Cessna 172E · S/N 17250758 · Cancelled May 20, 1965 · Eastair Corp
- [N4117F](https://openairdocs.org/deregistered/N4117F-1965-05-20.md): Cessna 172 · S/N 46017 · Cancelled May 20, 1965 · Eastair Corp
- [N2456G](https://openairdocs.org/deregistered/N2456G-1965-05-18.md): Cessna 182 · S/N 51756 · Cancelled May 18, 1965 · Built 1959 · Eastair Corp
- [N8031C](https://openairdocs.org/deregistered/N8031C-1960-01-16.md): Piper PA-22-135 · S/N 22-2218 · Cancelled Jan 16, 1960 · Exported to United Kingdom · R I Airways Inc
- [N246B](https://openairdocs.org/deregistered/N246B-1959-08-26.md): Colonial C-1 · S/N 5 · Cancelled Aug 26, 1959 · Exported to Canada · Eastair Corp
- [N89790](https://openairdocs.org/deregistered/N89790-1959-04-08.md): Cessna 140 · S/N 8839 · Cancelled Apr 8, 1959 · Exported to Canada · Built 1946 · Jennings Bros Air Service Inc
- [N915B](https://openairdocs.org/deregistered/N915B-1956-10-24.md): Bell 47B · S/N 5 · Cancelled Oct 24, 1956 · Exported to Canada · New England Helicopter Ser Inc

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

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