# Earlier aircraft under this name: Babb Charles H

A list on [Babb Charles H](https://openairdocs.org/faa-owner/BABB%20CHARLES%20H.md).

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

- [N9721](https://openairdocs.org/deregistered/N9721-1949-09-29.md): Fairchild FC-2-W2 · S/N 535 · Cancelled Sep 29, 1949 · Glendale, CA
- [N13757](https://openairdocs.org/deregistered/N13757-1948-05-03.md): Northrop GAMMA 2D · S/N 8 · Cancelled May 3, 1948 · Glendale, CA
- [N239M](https://openairdocs.org/deregistered/N239M-1948-03-22.md): Detroit VEGA DL-1 · S/N 156 · Cancelled Mar 22, 1948 · Built 1930 · Glendale, CA
- [N2875](https://openairdocs.org/deregistered/N2875-1943-03-17.md): Lockheed VEGA 5C · S/N 60 · Cancelled Mar 17, 1943 · Exported to Mexico
- [N905Y](https://openairdocs.org/deregistered/N905Y-1943-03-17.md): Lockheed VEGA 5C · S/N 133 · Cancelled Mar 17, 1943 · Built 1930 · New York, NY
- [N15107](https://openairdocs.org/deregistered/N15107-1940-09-01.md): Stinson A · S/N 9107 · Cancelled Sep 1, 1940 · Built 1935 · Glendale, CA
- [N22570](https://openairdocs.org/deregistered/N22570-1940-08-10.md): Stinson HW75 · S/N 7097 · Cancelled Aug 10, 1940 · Exported to Canada · New York, NY
- [N13346](https://openairdocs.org/deregistered/N13346-1940-06-20.md): Boeing 247D · S/N 1728 · Cancelled Jun 20, 1940 · Exported to Canada · Built 1933 · New York, NY
- [N9973](https://openairdocs.org/deregistered/N9973-1939-06-07.md): Travel Air A-6000-A · S/N 1094 · Cancelled Jun 7, 1939 · Exported to Mexico · Glendale, CA
- [N12297](https://openairdocs.org/deregistered/N12297-1938-10-05.md): Bach 3-CT-9K · S/N 23 · Cancelled Oct 5, 1938 · Exported to Mexico · Built 1933 · Glendale, CA
- [N17307](https://openairdocs.org/deregistered/N17307-1938-08-25.md): Ryan Aeronautical ST-A SPECIAL · S/N 141 · Cancelled Aug 25, 1938 · Exported to Nicaragua · Glendale, CA
- [N376M](https://openairdocs.org/deregistered/N376M-1938-04-23.md): Travel Air A-6000-A · S/N A6A-2002 · Cancelled Apr 23, 1938 · Exported to Costa Rica · Built 1930 · Glendale, CA
- [N233M](https://openairdocs.org/deregistered/N233M-1937-10-12.md): Boeing 80-A · S/N 1091 · Cancelled Oct 12, 1937 · Glendale, CA
- [N12364](https://openairdocs.org/deregistered/N12364-1937-09-27.md): Curtiss-Wright T-32-C CONDOR II · S/N 24 · Cancelled Sep 27, 1937 · Built 1933 · Glendale, CA
- [N12397](https://openairdocs.org/deregistered/N12397-1937-09-27.md): Curtiss Wrightairplane AT-32-D · S/N 49 · Cancelled Sep 27, 1937 · Glendale, CA
- [N10357](https://openairdocs.org/deregistered/N10357-1936-11-21.md): Boeing 40-B-4 · S/N 1438 · Cancelled Nov 21, 1936 · Exported to Nicaragua
- [N9975](https://openairdocs.org/deregistered/N9975-1936-02-25.md): Travel Air A-6000-A · S/N 1096 · Cancelled Feb 25, 1936 · Glendale, 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 = 'BABB CHARLES H' OR list_contains(d.other_registrant_names, 'BABB CHARLES H')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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