# Earlier aircraft under this name: West Indies Airways

A list on [West Indies Airways](https://openairdocs.org/faa-owner/WEST%20INDIES%20AIRWAYS.md).

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

- [N2659D](https://openairdocs.org/deregistered/N2659D-2020-03-20.md): Cessna 170B · S/N 20811 · Cancelled Mar 20, 2020 · Revoked, canceled · Built 1952 · San Juan, PR
- [N42848](https://openairdocs.org/deregistered/N42848-2019-05-15.md): Piper J3C-65 · S/N 15168 · Cancelled May 15, 2019 · Revoked, pending cancellation · Built 1945 · San Juan, PR
- [N3978N](https://openairdocs.org/deregistered/N3978N-2018-04-05.md): Beech 35 · S/N D-736 · Cancelled Apr 5, 2018 · Revoked, canceled · Built 1947 · San Juan, PR
- [N5734C](https://openairdocs.org/deregistered/N5734C-1956-07-09.md): Cessna 170A · S/N 19688 · Cancelled Jul 9, 1956 · San Juan
- [N66100](https://openairdocs.org/deregistered/N66100-1956-03-22.md): Cessna T-50 · S/N 5010 · Cancelled Mar 22, 1956 · San Juan
- [N66059](https://openairdocs.org/deregistered/N66059-1956-03-14.md): Piper J3C-65 · S/N 8697 · Cancelled Mar 14, 1956 · Built 1941 · San Juan, PR
- [N42291](https://openairdocs.org/deregistered/N42291-1956-02-28.md): Piper J3C-65 · S/N 14541 · Cancelled Feb 28, 1956
- [N55473](https://openairdocs.org/deregistered/N55473-1955-12-22.md): Piper J3C-65 · S/N 8728 · Cancelled Dec 22, 1955 · San Juan
- [N55476](https://openairdocs.org/deregistered/N55476-1955-12-22.md): Piper J3C-65 · S/N 8807 · Cancelled Dec 22, 1955 · San Juan
- [N55471](https://openairdocs.org/deregistered/N55471-1955-12-01.md): Piper J3C-65 · S/N 8747 · Cancelled Dec 1, 1955 · San Juan
- [N1102M](https://openairdocs.org/deregistered/N1102M-1955-11-15.md): Fairchild 24W-41A · S/N 3521 · Cancelled Nov 15, 1955
- [N1101M](https://openairdocs.org/deregistered/N1101M-1955-03-15.md): Boeing E75N1 · S/N 75-8118 · Cancelled Mar 15, 1955
- [N55404](https://openairdocs.org/deregistered/N55404-1950-11-10.md): Boeing PT-13A · S/N 75-092 · Cancelled Nov 10, 1950 · Built 1938 · San Juan, PR
- [N41189](https://openairdocs.org/deregistered/N41189-1950-11-06.md): Piper J3L-65 · S/N 7814 · Cancelled Nov 6, 1950
- [N55475](https://openairdocs.org/deregistered/N55475-1949-01-05.md): Piper J3C-65 · S/N 8765 · Cancelled Jan 5, 1949 · Built 1942 · San Juan, PR
- [N55470](https://openairdocs.org/deregistered/N55470-1948-12-28.md): Piper J3C-65 · S/N 8148 · Cancelled Dec 28, 1948 · San Juan, PR
- [N66101](https://openairdocs.org/deregistered/N66101-undated.md): Cessna T-50 · S/N 5009 · Cancellation date not recorded · San Juan, PR

## 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 = 'WEST INDIES AIRWAYS' OR list_contains(d.other_registrant_names, 'WEST INDIES AIRWAYS')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-owner/WEST%20INDIES%20AIRWAYS/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.