# Earlier aircraft under this name: Bartelt Aviation Inc

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

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

- [N26093](https://openairdocs.org/deregistered/N26093-2017-12-26.md): Piper PA-38-112 · S/N 38-81A0115 · Cancelled Dec 26, 2017 · Built 1981 · Sturgis, MI
- [N132MS](https://openairdocs.org/deregistered/N132MS-2006-05-01.md): Mooney M20J · S/N 24-3411 · Cancelled May 1, 2006 · Exported to Belgium · Built 1997 · Sturgis, MI
- [N433FM](https://openairdocs.org/deregistered/N433FM-2002-09-27.md): Mooney M20J · S/N 24-3419 · Cancelled Sep 27, 2002 · Exported to Italy · Built 1998 · Sturgis, MI
- [N8052Z](https://openairdocs.org/deregistered/N8052Z-2002-07-16.md): Cessna U206A · S/N U206-0452 · Cancelled Jul 16, 2002 · Exported to Guatemala · Built 1965 · Sturgis, MI
- [N648CA](https://openairdocs.org/deregistered/N648CA-1998-08-14.md): Cessna 152 · S/N 15281455 · Cancelled Aug 14, 1998 · Exported to Belgium · Sturgis, MI
- [N733GA](https://openairdocs.org/deregistered/N733GA-1996-07-11.md): Cessna 172N · S/N 17268274 · Cancelled Jul 11, 1996 · Exported to Belgium · Sturgis, MI
- [N1660U](https://openairdocs.org/deregistered/N1660U-1995-02-28.md): Cessna T210N · S/N 21064719 · Cancelled Feb 28, 1995 · Exported to Mexico · Sturgis, MI
- [N8202H](https://openairdocs.org/deregistered/N8202H-1993-08-11.md): Piper PA-32RT-301T · S/N 32R8229048 · Cancelled Aug 11, 1993 · Exported to Germany · Sturgis, MI
- [N5124P](https://openairdocs.org/deregistered/N5124P-1993-07-07.md): Cessna 152 · S/N 15284883 · Cancelled Jul 7, 1993 · Exported to Belgium · Sturgis, MI
- [N68927](https://openairdocs.org/deregistered/N68927-1993-07-01.md): Cessna 152 · S/N 15282406 · Cancelled Jul 1, 1993 · Exported to Belgium · Sturgis, MI
- [N4375G](https://openairdocs.org/deregistered/N4375G-1992-05-13.md): Cessna TU206G · S/N U20605455 · Cancelled May 13, 1992 · Exported to Belgium · Sturgis, MI
- [N8095R](https://openairdocs.org/deregistered/N8095R-1991-02-19.md): Piper PA-32RT-301T · S/N 32R8229031 · Cancelled Feb 19, 1991 · Exported to Germany · Sturgis, MI
- [N42989](https://openairdocs.org/deregistered/N42989-1991-01-02.md): Piper PA-32R-301T · S/N 32R8329022 · Cancelled Jan 2, 1991 · Exported to Belgium · Sturgis, MI
- [N2287M](https://openairdocs.org/deregistered/N2287M-1981-05-13.md): Piper PA-28-161 · S/N 28-7816272 · Cancelled May 13, 1981 · Exported to Iceland · Built 1977 · Kalamazoo, MI
- [N27837](https://openairdocs.org/deregistered/N27837-1979-04-27.md): Piper PA-31-325 · S/N 31-7912011 · Cancelled Apr 27, 1979 · Exported to Canada · Built 1978 · Kalamazoo, MI
- [N2369A](https://openairdocs.org/deregistered/N2369A-1978-09-29.md): Piper PA-38-112 · S/N 3878A0658 · Cancelled Sep 29, 1978 · Exported to Canada · Kalamazoo, MI

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

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