# Earlier aircraft under this name: Red S Aircraft Sales

A list on [Red S Aircraft Sales](https://openairdocs.org/faa-owner/RED%20S%20AIRCRAFT%20SALES.md).

Cancelled registrations that named this owner when they ended, newest first.

- [N215AC](https://openairdocs.org/deregistered/N215AC-2011-03-09.md): Bell TH-13T · S/N 67-17093 · Cancelled Mar 9, 2011 · Expired dealer · Built 1967 · Stevenson Red DBA, Haskell, OK
- [N1155W](https://openairdocs.org/deregistered/N1155W-2003-09-03.md): Bell 47J-2A · S/N 3126 · Cancelled Sep 3, 2003 · Second triennial mailing, no response · Built 1964 · Stevenson Red DBA, Leonard, OK
- [N28894](https://openairdocs.org/deregistered/N28894-2003-09-03.md): Bell 47G-2 · S/N 2070 · Cancelled Sep 3, 2003 · Second triennial mailing, no response · Built 1963 · Stevenson Red DBA, Leonard, OK
- [N5354A](https://openairdocs.org/deregistered/N5354A-2003-09-03.md): Cessna 310B · S/N 35554 · Cancelled Sep 3, 2003 · Built 1957 · Stevenson Red DBA, Haskell, OK
- [N5393Q](https://openairdocs.org/deregistered/N5393Q-2003-09-03.md): Piper PA-23-250 · S/N 27-7305009 · Cancelled Sep 3, 2003 · Built 1973 · Stevenson Red DBA, Jenks, OK
- [N704LM](https://openairdocs.org/deregistered/N704LM-2003-09-03.md): Cessna 150M · S/N 15078696 · Cancelled Sep 3, 2003 · Second triennial mailing, no response · Built 1976 · Stevenson Red DBA, Leonard, OK
- [N7320M](https://openairdocs.org/deregistered/N7320M-2003-09-03.md): Cessna 210M · S/N 21062008 · Cancelled Sep 3, 2003 · Second triennial mailing, no response · Built 1977 · Stevenson Red DBA, Leonard, OK
- [N759XS](https://openairdocs.org/deregistered/N759XS-2003-09-03.md): Cessna 182Q · S/N 18266346 · Cancelled Sep 3, 2003 · Second triennial mailing, no response · Built 1978 · Stevenson Red DBA, Jenks, OK
- [N8716Q](https://openairdocs.org/deregistered/N8716Q-2003-09-03.md): Cessna TU206F · S/N U20603469 · Cancelled Sep 3, 2003 · Second triennial mailing, no response · Built 1976 · Stevenson Red DBA, Jenks, OK
- [N951E](https://openairdocs.org/deregistered/N951E-2003-09-03.md): Cessna 210A · S/N 21057832 · Cancelled Sep 3, 2003 · Built 1961 · Stevenson Red DBA, Jenks, OK
- [N128B](https://openairdocs.org/deregistered/N128B-2003-08-19.md): Bell 47B · S/N 48 · Cancelled Aug 19, 2003 · Second triennial mailing, no response · Built 1947 · Stevenson Red DBA, Jenks, OK
- [N15CA](https://openairdocs.org/deregistered/N15CA-2003-08-19.md): Cessna 421A · S/N 421A0111 · Cancelled Aug 19, 2003 · Second triennial mailing, no response · Built 1969 · Stevenson Red DBA, Tulsa, OK
- [N7959Y](https://openairdocs.org/deregistered/N7959Y-2003-08-19.md): Piper PA-30 · S/N 30-1056 · Cancelled Aug 19, 2003 · Built 1966 · Stevenson Red DBA, Haskell, OK
- [N9257](https://openairdocs.org/deregistered/N9257-2003-08-19.md): Enstrom F-28A · S/N 232 · Cancelled Aug 19, 2003 · Second triennial mailing, no response · Built 1974 · Stevenson Red DBA, Leonard, OK
- [N1525T](https://openairdocs.org/deregistered/N1525T-1994-01-27.md): Bell UH-1B · S/N 622089 · Cancelled Jan 27, 1994 · Exported to Guatemala · Stevenson Red DBA, Bixby, OK
- [N81199](https://openairdocs.org/deregistered/N81199-1979-09-18.md): Grumman American Avn. AA-5B · S/N AA5B-0456 · Cancelled Sep 18, 1979 · Exported to Canada · Leonard, OK

## 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_name = 'RED S AIRCRAFT SALES' OR list_contains(d.other_registrant_names, 'RED S AIRCRAFT SALES')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/RED%20S%20AIRCRAFT%20SALES/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
