# Earlier aircraft under this name: Civil Aeronautics Administration

A list on [Civil Aeronautics Administration](https://openairdocs.org/faa-owner/CIVIL%20AERONAUTICS%20ADMINISTRATION.md).

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

Page 1 of 2 · 55 registrations

- [N19](https://openairdocs.org/deregistered/N19-1950-10-02.md): Beech C18S · S/N 6263 · Cancelled Oct 2, 1950 · Washington, DC
- [N51](https://openairdocs.org/deregistered/N51-1949-06-23.md): Beech C18S · S/N 6203 · Cancelled Jun 23, 1949
- [N204](https://openairdocs.org/deregistered/N204-1948-10-08.md): Beech C-45 · S/N 372 · Cancelled Oct 8, 1948 · Built 1940 · Washington, DC
- [N41577](https://openairdocs.org/deregistered/N41577-1948-09-13.md): Piper J3C-65 · S/N 8218 · Cancelled Sep 13, 1948 · Washington, DC
- [N272](https://openairdocs.org/deregistered/N272-1948-07-14.md): North American AT-6B · S/N 88-9563 · Cancelled Jul 14, 1948 · Built 1942 · Washington, DC
- [N312](https://openairdocs.org/deregistered/N312-1948-07-14.md): North American SNJ-4 · S/N 10892 · Cancelled Jul 14, 1948 · Built 1942 · Washington 25, DC
- [N313](https://openairdocs.org/deregistered/N313-1948-07-14.md): North American SNJ-4 · S/N 11007 · Cancelled Jul 14, 1948 · Built 1942 · Washington, DC
- [N315](https://openairdocs.org/deregistered/N315-1948-07-14.md): North American SNJ-4 · S/N 10902 · Cancelled Jul 14, 1948 · Built 1942 · Washington, DC
- [N317](https://openairdocs.org/deregistered/N317-1948-07-14.md): North American SNJ-4 · S/N 9562 · Cancelled Jul 14, 1948 · Built 1942 · Washington, DC
- [N320](https://openairdocs.org/deregistered/N320-1948-07-14.md): North American SNJ-4 · S/N 11008 · Cancelled Jul 14, 1948 · Built 1942 · Washington, DC
- [N323](https://openairdocs.org/deregistered/N323-1948-07-14.md): North American SNJ-4 · S/N 9365 · Cancelled Jul 14, 1948 · Built 1942 · Washington, DC
- [N328](https://openairdocs.org/deregistered/N328-1948-07-14.md): North American SNJ-4 · S/N 10315 · Cancelled Jul 14, 1948 · Built 1942 · Washington, DC
- [N360](https://openairdocs.org/deregistered/N360-1948-07-14.md): North American AT-6C · S/N 10887 · Cancelled Jul 14, 1948 · Washington, DC
- [N252](https://openairdocs.org/deregistered/N252-1948-06-23.md): North American SNJ-4 · S/N 9598 · Cancelled Jun 23, 1948 · Built 1942 · Washington, DC
- [N262](https://openairdocs.org/deregistered/N262-1948-06-23.md): North American SNJ-4 · S/N 9804 · Cancelled Jun 23, 1948
- [N273](https://openairdocs.org/deregistered/N273-1948-06-23.md): North American SNJ-4 · S/N 10293 · Cancelled Jun 23, 1948 · Washington, DC
- [N331](https://openairdocs.org/deregistered/N331-1948-06-23.md): North American SNJ-4 · S/N 88-9091 · Cancelled Jun 23, 1948 · Built 1942 · Washington, DC
- [N388](https://openairdocs.org/deregistered/N388-1948-06-23.md): North American AT-6C · S/N 9159 · Cancelled Jun 23, 1948 · Washington, DC
- [N355](https://openairdocs.org/deregistered/N355-1948-06-10.md): North American AT-6C · S/N 88-9765 · Cancelled Jun 10, 1948 · Built 1942
- [N376](https://openairdocs.org/deregistered/N376-1948-06-10.md): North American AT-6C(SNJ-4) · S/N 88-9454 · Cancelled Jun 10, 1948 · Built 1942
- [N263](https://openairdocs.org/deregistered/N263-1948-06-09.md): North American AT-6 · S/N 88-11033 · Cancelled Jun 9, 1948 · Washington, DC
- [N285](https://openairdocs.org/deregistered/N285-1948-06-09.md): North American AT-6C · S/N 10713 · Cancelled Jun 9, 1948 · Wshington, DC
- [N308](https://openairdocs.org/deregistered/N308-1948-06-09.md): North American SNJ-4 · S/N 10320 · Cancelled Jun 9, 1948 · Built 1942 · Oklahoma City, OK
- [N310](https://openairdocs.org/deregistered/N310-1948-06-09.md): North American AT-6C · S/N 10230 · Cancelled Jun 9, 1948 · Washington, DC
- [N85](https://openairdocs.org/deregistered/N85-1948-03-03.md): Stinson SR-9E · S/N 5408 · Cancelled Mar 3, 1948 · Washington, DC
- [N10](https://openairdocs.org/deregistered/N10-1947-06-30.md): Beech D17S · S/N 6756 · Cancelled Jun 30, 1947 · Washington, DC
- [N271](https://openairdocs.org/deregistered/N271-1947-06-30.md): North American SNJ-4 · S/N 1135 · Cancelled Jun 30, 1947 · Built 1942 · Washington, DC
- [N349](https://openairdocs.org/deregistered/N349-1947-04-22.md): North American SNJ-4 · S/N 10322 · Cancelled Apr 22, 1947 · Washington, DC
- [N28](https://openairdocs.org/deregistered/N28-1947-04-14.md): Beech C18S · S/N 4225 · Cancelled Apr 14, 1947 · Fort Worth, TX
- [N216](https://openairdocs.org/deregistered/N216-1947-01-28.md): Beech GB-2 · S/N 23668 · Cancelled Jan 28, 1947 · Washington, DC
- [N332](https://openairdocs.org/deregistered/N332-1947-01-28.md): North American SNJ-4 · S/N 10181 · Cancelled Jan 28, 1947 · Built 1942 · Washington, DC
- [N339](https://openairdocs.org/deregistered/N339-1947-01-28.md): North American SNJ-4 · S/N 11212 · Cancelled Jan 28, 1947 · Washington, DC
- [N78](https://openairdocs.org/deregistered/N78-1947-01-28.md): Beech B18S · S/N 6576 · Cancelled Jan 28, 1947 · Ft Worth, TX
- [N330](https://openairdocs.org/deregistered/N330-1947-01-24.md): North American SNJ-4 · S/N 10225 · Cancelled Jan 24, 1947 · Built 1942 · Washington, DC
- [N42](https://openairdocs.org/deregistered/N42-1947-01-24.md): Beech D17S · S/N 285 · Cancelled Jan 24, 1947 · Washington, DC
- [N39](https://openairdocs.org/deregistered/N39-1946-12-23.md): Beech C18S · S/N 292 · Cancelled Dec 23, 1946 · Washington, DC
- [N74](https://openairdocs.org/deregistered/N74-1946-10-10.md): Beech C18S · S/N 7145 · Cancelled Oct 10, 1946 · Washington, DC
- [N39](https://openairdocs.org/deregistered/N39-1946-07-29.md): Fairchild 24 G · S/N 2936 · Cancelled Jul 29, 1946 · Washington, DC
- [N290](https://openairdocs.org/deregistered/N290-1946-07-24.md): Standard J-1 · S/N 4871 · Cancelled Jul 24, 1946 · Washington, DC
- [N20](https://openairdocs.org/deregistered/N20-1946-07-16.md): Fairchild 24 G · S/N 2923 · Cancelled Jul 16, 1946 · Washington D C, DC
- [N7](https://openairdocs.org/deregistered/N7-1946-03-20.md): Cessna T-50 · S/N 1310 · Cancelled Mar 20, 1946 · Washington, DC
- [N328](https://openairdocs.org/deregistered/N328-1946-03-01.md): Consolidated Vultee BT-13 · S/N 2985 · Cancelled Mar 1, 1946 · Washington, DC
- [N308](https://openairdocs.org/deregistered/N308-1946-02-27.md): Consolidated Vultee BT-13 · S/N 6525 · Cancelled Feb 27, 1946 · Oklahoma City, OK
- [N325](https://openairdocs.org/deregistered/N325-1946-02-27.md): Consolidated Vultee BT-13A · S/N 6035 · Cancelled Feb 27, 1946 · Built 1945 · Washington, DC
- [N272](https://openairdocs.org/deregistered/N272-1946-02-26.md): Vultee BT-13 · S/N 6808 · Cancelled Feb 26, 1946 · Washington, DC
- [N221](https://openairdocs.org/deregistered/N221-1946-02-25.md): Waco UPF-7 · S/N 5304 · Cancelled Feb 25, 1946 · Built 1939 · Washington, DC
- [N318](https://openairdocs.org/deregistered/N318-1946-02-25.md): Consolidated Vultee BT-13A · S/N 2333 · Cancelled Feb 25, 1946 · Washington, DC
- [N93](https://openairdocs.org/deregistered/N93-1946-02-25.md): Fairchild 24W-9 · S/N 107 · Cancelled Feb 25, 1946 · Washington, DC
- [N208](https://openairdocs.org/deregistered/N208-1946-02-21.md): Fairchild M-62A · S/N T41-939 · Cancelled Feb 21, 1946 · Washington, DC
- [N120](https://openairdocs.org/deregistered/N120-1946-01-17.md): Interstate S-1A · S/N 122 · Cancelled Jan 17, 1946 · Washington, DC

Next page: https://openairdocs.org/faa-owner/CIVIL%20AERONAUTICS%20ADMINISTRATION/earlier.md?page=2

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

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