# Earlier aircraft under this name: Compass Aircraft Group Inc

A list on [Compass Aircraft Group Inc](https://openairdocs.org/faa-owner/COMPASS%20AIRCRAFT%20GROUP%20INC.md).

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

- [N22605](https://openairdocs.org/deregistered/N22605-2018-10-23.md): Beech 95-B55 (T42A) · S/N TC-2102 · Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Built 1977 · Wichitaton, KS
- [N375H](https://openairdocs.org/deregistered/N375H-2014-09-16.md): Raytheon G36 · S/N E-3752 · Cancelled Sep 16, 2014 · Exported to Brazil · Wichita, KS
- [N423LA](https://openairdocs.org/deregistered/N423LA-2014-09-04.md): Air Tractor AT-402A · S/N 402A-1123 · Cancelled Sep 4, 2014 · Exported to Brazil · Built 2000 · Wichita, KS
- [N878C](https://openairdocs.org/deregistered/N878C-2014-05-29.md): Raytheon 58 · S/N TH-2109 · Cancelled May 29, 2014 · Exported to Brazil · Wichita, KS
- [N5432D](https://openairdocs.org/deregistered/N5432D-2014-05-14.md): Cessna 172N · S/N 17272568 · Cancelled May 14, 2014 · Exported to Brazil · Built 1979 · Wichita, KS
- [N2WF](https://openairdocs.org/deregistered/N2WF-2014-03-21.md): Hawker Beechcraft G58 · S/N TH-2330 · Cancelled Mar 21, 2014 · Exported to Brazil · Built 2011 · Wichita, KS
- [N1946F](https://openairdocs.org/deregistered/N1946F-2013-06-25.md): Cessna 172N · S/N 17273036 · Cancelled Jun 25, 2013 · Exported to Brazil · Built 1979 · Wichita, KS
- [N63570](https://openairdocs.org/deregistered/N63570-2013-06-21.md): Cessna 150M · S/N 15077400 · Cancelled Jun 21, 2013 · Exported to Brazil · Built 1975 · Wichita, KS
- [N6420K](https://openairdocs.org/deregistered/N6420K-2013-06-21.md): Cessna 150M · S/N 15077695 · Cancelled Jun 21, 2013 · Exported to Brazil · Built 1975 · Wichita, KS
- [N930DJ](https://openairdocs.org/deregistered/N930DJ-2013-04-24.md): Raytheon 58 · S/N TH-1946 · Cancelled Apr 24, 2013 · Exported to Brazil · Built 2000 · Wichita, KS
- [N563TC](https://openairdocs.org/deregistered/N563TC-2013-04-22.md): Hawker Beechcraft C90GTI · S/N LJ-2014 · Cancelled Apr 22, 2013 · Exported to Brazil · Built 2011 · Wichita, KS
- [N75WL](https://openairdocs.org/deregistered/N75WL-2012-10-24.md): Piper PA-31T2 · S/N 31T-8166029 · Cancelled Oct 24, 2012 · Exported to Brazil · Wichita, KS
- [N509WH](https://openairdocs.org/deregistered/N509WH-2012-06-19.md): Raytheon 58 · S/N TH-2009 · Cancelled Jun 19, 2012 · Exported to Brazil · Built 2001 · Wichita, KS
- [N1177D](https://openairdocs.org/deregistered/N1177D-2012-05-23.md): Cessna 206H · S/N 20608068 · Cancelled May 23, 2012 · Exported to Brazil · Wichita, KS
- [N3134R](https://openairdocs.org/deregistered/N3134R-2012-01-25.md): New Piper PA-32R-301T · S/N 3257420 · Cancelled Jan 25, 2012 · Exported to Brazil · Built 2006 · Wichita, KS
- [N71CT](https://openairdocs.org/deregistered/N71CT-2012-01-25.md): Raytheon 58 · S/N TH-2107 · Cancelled Jan 25, 2012 · Exported to Brazil · Wichita, KS

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

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