# Earlier aircraft under this name: Jetsteam Aviation Inc

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

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

- [N720PT](https://openairdocs.org/deregistered/N720PT-2023-03-22.md): British Aerospace HS 125-700A · S/N NA0223 · Cancelled Mar 22, 2023 · Exported to Mexico · Built 1978 · Cheyenne, WY
- [N444ET](https://openairdocs.org/deregistered/N444ET-2022-09-15.md): Canadair CL-600 CHALLENGER · S/N 1062 · Cancelled Sep 15, 2022 · Exported to Mexico · Built 1982 · Cheyenne, WY
- [N441KR](https://openairdocs.org/deregistered/N441KR-2022-02-07.md): Cessna 441 · S/N 4410079 · Cancelled Feb 7, 2022 · Exported to Mexico · Built 1978 · Cheyenne, WY
- [N515RM](https://openairdocs.org/deregistered/N515RM-2022-01-18.md): Piper PA-31-350 · S/N 31-7405159 · Cancelled Jan 18, 2022 · Exported to Mexico · Built 1974 · Cheyenne, WY
- [N47LV](https://openairdocs.org/deregistered/N47LV-2021-12-28.md): Canadair CL-600-1A11 · S/N 1026 · Cancelled Dec 28, 2021 · Exported to Mexico · Cheyenne, WY
- [N152TW](https://openairdocs.org/deregistered/N152TW-2021-10-12.md): Beech 200 · S/N BB-152 · Cancelled Oct 12, 2021 · Exported to Mexico · Cheyenne, WY
- [N4850C](https://openairdocs.org/deregistered/N4850C-2020-10-30.md): Cessna T210N · S/N 21063645 · Cancelled Oct 30, 2020 · Exported to Mexico · Built 1979 · Cheyenne, WY
- [N69489](https://openairdocs.org/deregistered/N69489-2020-04-03.md): Cessna 340 · S/N 340-0330 · Cancelled Apr 3, 2020 · Registration expired, pending cancellation · Built 1974 · Cheyenne, WY
- [N998BA](https://openairdocs.org/deregistered/N998BA-2020-03-25.md): Cessna T210M · S/N 21061710 · Cancelled Mar 25, 2020 · Exported to Mexico · Cheyenne, WY
- [N5234V](https://openairdocs.org/deregistered/N5234V-2019-09-25.md): Cessna 210L · S/N 21060874 · Cancelled Sep 25, 2019 · Exported to Mexico · Built 1975 · Cheyenne, WY
- [N1743E](https://openairdocs.org/deregistered/N1743E-2019-09-24.md): Cessna 310R · S/N 310R1559 · Cancelled Sep 24, 2019 · Exported to Mexico · Built 1979 · Cheyenne, WY
- [N130LS](https://openairdocs.org/deregistered/N130LS-2019-04-15.md): Piper PA-31-350 · S/N 31-7752140 · Cancelled Apr 15, 2019 · Exported to Mexico · Built 1977 · Cheyenne, WY
- [N114SB](https://openairdocs.org/deregistered/N114SB-2019-03-18.md): Beech 200 · S/N BB-161 · Cancelled Mar 18, 2019 · Exported to Mexico · Cheyenne, WY
- [N689JE](https://openairdocs.org/deregistered/N689JE-2019-01-22.md): Gulfstream American G-1159 · S/N 258 · Cancelled Jan 22, 2019 · Exported to Ecuador · Built 1979 · Cheyenne, WY
- [N412JT](https://openairdocs.org/deregistered/N412JT-2014-12-11.md): Grumman G-1159 · S/N 101 · Cancelled Dec 11, 2014 · Third renewal notice · Built 1970 · Cheyenne, WY
- [N268WC](https://openairdocs.org/deregistered/N268WC-2014-12-10.md): Gates Learjet 25D · S/N 268 · Cancelled Dec 10, 2014 · Third renewal notice · Cheyenne, WY

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

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