# Earlier aircraft under this name: Aircraft Specialties Inc

A list on [Aircraft Specialties Inc](https://openairdocs.org/faa-owner/AIRCRAFT%20SPECIALTIES%20INC.md).

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

- [N6718C](https://openairdocs.org/deregistered/N6718C-1980-11-05.md): Lockheed PV-2 · S/N 151415 · Cancelled Nov 5, 1980 · Mesa, AZ
- [N6228C](https://openairdocs.org/deregistered/N6228C-1979-05-16.md): Lockheed 1049C · S/N 4536 · Cancelled May 16, 1979 · Exported to Dominican Republic · Mesa, AZ
- [N9500F](https://openairdocs.org/deregistered/N9500F-1977-07-19.md): Hughes 269B · S/N 980391 · Cancelled Jul 19, 1977 · Vancouver, WA
- [N67036](https://openairdocs.org/deregistered/N67036-1977-07-14.md): Sikorsky S-55B · S/N 55716 · Cancelled Jul 14, 1977 · Mesa, AZ
- [N67157](https://openairdocs.org/deregistered/N67157-1977-07-14.md): Sikorsky S-55B · S/N 55661 · Cancelled Jul 14, 1977 · Mesa, AZ
- [N67158](https://openairdocs.org/deregistered/N67158-1977-07-14.md): Sikorsky S-55B · S/N 551202 · Cancelled Jul 14, 1977 · Mesa, AZ
- [N621L](https://openairdocs.org/deregistered/N621L-1976-05-26.md): Boeing B-17G · S/N 44-85774 · Cancelled May 26, 1976 · Built 1944 · Mesa, AZ
- [N230Z](https://openairdocs.org/deregistered/N230Z-1975-10-06.md): Lockheed PV-2 · S/N 151603 · Cancelled Oct 6, 1975 · Built 1945 · Mesa, AZ
- [N45516](https://openairdocs.org/deregistered/N45516-1975-09-05.md): Lockheed 1049H · S/N 4840 · Cancelled Sep 5, 1975 · Built 1956 · Mesa, AZ
- [N75216](https://openairdocs.org/deregistered/N75216-1975-04-04.md): Sikorsky S-55B · S/N 55-965 · Cancelled Apr 4, 1975 · Exported to Canada · Mesa, AZ
- [N7858](https://openairdocs.org/deregistered/N7858-1974-08-29.md): Sikorsky S-55B · S/N 55989 · Cancelled Aug 29, 1974 · Mesa, AZ
- [N173W](https://openairdocs.org/deregistered/N173W-1974-05-07.md): Lockheed 1049G · S/N 4674 · Cancelled May 7, 1974 · Mesa, AZ
- [N7820T](https://openairdocs.org/deregistered/N7820T-1974-04-26.md): Cessna 172A · S/N 47420 · Cancelled Apr 26, 1974 · Vancouver, WA
- [N620L](https://openairdocs.org/deregistered/N620L-1973-10-01.md): Boeing B-17G · S/N 44-85840 · Cancelled Oct 1, 1973 · Mesa, AZ
- [N9163Z](https://openairdocs.org/deregistered/N9163Z-1973-06-07.md): Douglas TB-26B · S/N 44-34659 · Cancelled Jun 7, 1973 · Exported to Canada · Mesa, AZ
- [N3073C](https://openairdocs.org/deregistered/N3073C-1972-03-31.md): Beech K35 · S/N D-5737 · Cancelled Mar 31, 1972 · Vancouver, WA
- [N9926Z](https://openairdocs.org/deregistered/N9926Z-1970-08-27.md): Grumman TBM-3E · S/N 91474 · Cancelled Aug 27, 1970 · Mesa, AZ

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

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