# Earlier aircraft under this name: Champs Aviation Inc

A list on [Champs Aviation Inc](https://openairdocs.org/faa-owner/CHAMPS%20AVIATION%20INC.md).

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

- [N6848R](https://openairdocs.org/deregistered/N6848R-1970-07-13.md): Cessna T210G · S/N T210-0248 · Cancelled Jul 13, 1970 · Exported to France · El Paso, TX
- [N6339F](https://openairdocs.org/deregistered/N6339F-1970-05-12.md): Cessna 337A · S/N 337-0339 · Cancelled May 12, 1970 · El Paso, TX
- [N5066E](https://openairdocs.org/deregistered/N5066E-1970-03-13.md): Cessna 180B · S/N 50366 · Cancelled Mar 13, 1970 · Exported to Mexico · El Paso, TX
- [N6693F](https://openairdocs.org/deregistered/N6693F-1967-11-15.md): Cessna 150F · S/N 15063293 · Cancelled Nov 15, 1967 · El Paso, TX
- [N2348F](https://openairdocs.org/deregistered/N2348F-1967-11-14.md): Cessna 210 · S/N 21058548 · Cancelled Nov 14, 1967 · El Paso, TX
- [N7901U](https://openairdocs.org/deregistered/N7901U-1965-11-10.md): Cessna 172F · S/N 17251901 · Cancelled Nov 10, 1965 · Exported to Denmark · El Paso, TX
- [N6615B](https://openairdocs.org/deregistered/N6615B-1965-11-09.md): Cessna 310B · S/N 35715 · Cancelled Nov 9, 1965 · Exported to Mexico · El Paso, TX
- [N44558](https://openairdocs.org/deregistered/N44558-1965-05-22.md): Beech C18S · S/N 6166 · Cancelled May 22, 1965 · Built 1944 · Terminal, TX
- [N7255X](https://openairdocs.org/deregistered/N7255X-1965-05-22.md): Cessna 150B · S/N 15059355 · Cancelled May 22, 1965 · Lubbock, TX
- [N9406T](https://openairdocs.org/deregistered/N9406T-1965-05-21.md): Cessna 210 · S/N 57206 · Cancelled May 21, 1965 · El Paso, TX
- [N2841A](https://openairdocs.org/deregistered/N2841A-1963-08-19.md): Cessna 180 · S/N 30041 · Cancelled Aug 19, 1963 · Lubbock, TX
- [N72587](https://openairdocs.org/deregistered/N72587-1961-10-05.md): Cessna 140 · S/N 9759 · Cancelled Oct 5, 1961 · El Paso, TX
- [N2242E](https://openairdocs.org/deregistered/N2242E-1961-07-17.md): Aeronca 7AC · S/N 5816 · Cancelled Jul 17, 1961 · Exported to Mexico · Built 1946 · El Paso, TX
- [N2236G](https://openairdocs.org/deregistered/N2236G-1961-04-17.md): Cessna 182A · S/N 51536 · Cancelled Apr 17, 1961 · El Paso, TX
- [N6037B](https://openairdocs.org/deregistered/N6037B-1961-03-01.md): Cessna 182A · S/N 34037 · Cancelled Mar 1, 1961 · El Paso, TX
- [N83W](https://openairdocs.org/deregistered/N83W-1959-01-16.md): Piper PA-23 · S/N 23-560 · Cancelled Jan 16, 1959 · Exported to Mexico · El Paso, TX
- [N8326B](https://openairdocs.org/deregistered/N8326B-1958-03-07.md): Cessna 172 · S/N 36126 · Cancelled Mar 7, 1958 · Exported to Mexico · El Paso, TX

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

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