# Earlier aircraft under this name: Aero Union Corporation

A list on [Aero Union Corporation](https://openairdocs.org/faa-owner/AERO%20UNION%20CORPORATION.md).

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

- [N702AU](https://openairdocs.org/deregistered/N702AU-2007-06-06.md): Lockheed SP-2H · S/N 147968 · Cancelled Jun 6, 2007 · Triennial form not returned · Chico, CA
- [N62297](https://openairdocs.org/deregistered/N62297-2005-12-13.md): Douglas C-54E · S/N 27328 · Cancelled Dec 13, 2005 · Exported to Canada · Chico, CA
- [N713AU](https://openairdocs.org/deregistered/N713AU-2005-09-22.md): Lockheed SP-2H · S/N 145903 · Cancelled Sep 22, 2005 · Triennial form not returned · Chico, CA
- [N926AU](https://openairdocs.org/deregistered/N926AU-2005-05-13.md): Lockheed P3B · S/N 152731 · Cancelled May 13, 2005 · Triennial form not returned · Built 1966 · Chico, CA
- [N4994H](https://openairdocs.org/deregistered/N4994H-2002-02-07.md): Douglas C54D-DC · S/N 10653 · Cancelled Feb 7, 2002 · Exported to Canada · Built 1945 · Chico, CA
- [N62342](https://openairdocs.org/deregistered/N62342-2001-01-25.md): Douglas C54D-DC · S/N 10613 · Cancelled Jan 25, 2001 · Exported to Canada · Chico, CA
- [N11712](https://openairdocs.org/deregistered/N11712-2000-03-28.md): Douglas C54A-DC · S/N 3088 · Cancelled Mar 28, 2000 · Exported to Canada · Chico, CA
- [N703AU](https://openairdocs.org/deregistered/N703AU-2000-02-14.md): Lockheed P2V-7 · S/N 147967 · Cancelled Feb 14, 2000 · Exported to Chile · Chico, CA
- [N720AU](https://openairdocs.org/deregistered/N720AU-1998-06-25.md): Lockheed P2V-7 · S/N 145917 · Cancelled Jun 25, 1998 · Triennial form not returned · Chico, CA
- [N62295](https://openairdocs.org/deregistered/N62295-1997-08-27.md): Douglas C-54B · S/N 10428 · Cancelled Aug 27, 1997 · Triennial form not returned · Chico, CA
- [N1997](https://openairdocs.org/deregistered/N1997-1996-01-17.md): Boeing 727-23 · S/N 19128 · Cancelled Jan 17, 1996 · Chico, CA
- [N4989P](https://openairdocs.org/deregistered/N4989P-1995-08-26.md): Douglas C-54G · S/N 45629 · Cancelled Aug 26, 1995 · Triennial form not returned · Chico, CA
- [N924AU](https://openairdocs.org/deregistered/N924AU-1994-02-04.md): Lockheed P-3A · S/N 151359 · Cancelled Feb 4, 1994 · Triennial form not returned · Chico, CA
- [N8540](https://openairdocs.org/deregistered/N8540-1993-02-12.md): Vertol 42A · S/N 528623 · Cancelled Feb 12, 1993 · Triennial form not returned · Chico, CA
- [N48082](https://openairdocs.org/deregistered/N48082-1992-08-05.md): Boeing-Vertol CH-21C · S/N 5115886 · Cancelled Aug 5, 1992 · Triennial form not returned · Chico, CA
- [N67109](https://openairdocs.org/deregistered/N67109-1991-08-26.md): Douglas C54B-DC · S/N 10459 · Cancelled Aug 26, 1991 · Triennial form not returned · Chico, CA
- [N4958P](https://openairdocs.org/deregistered/N4958P-1981-05-08.md): Douglas C54G-DC · S/N 36090 · Cancelled May 8, 1981 · Exported to Canada · Chico, CA
- [N4820E](https://openairdocs.org/deregistered/N4820E-1974-11-25.md): Douglas A-26 · S/N 28017 · Cancelled Nov 25, 1974 · Exported to Canada · Chico, CA
- [N330WC](https://openairdocs.org/deregistered/N330WC-1972-02-17.md): Douglas B-26 · S/N 44-35456 · Cancelled Feb 17, 1972 · Exported to Canada · Chico, CA

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

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