# Earlier aircraft under this name: Robertson Aircraft Corp

A list on [Robertson Aircraft Corp](https://openairdocs.org/faa-owner/ROBERTSON%20AIRCRAFT%20CORP.md).

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

- [N37831](https://openairdocs.org/deregistered/N37831-1983-06-01.md): Robertson Stol B2RD · S/N RAC-B2-001 · Cancelled Jun 1, 1983 · Exported to France · Everett, WA
- [N26673](https://openairdocs.org/deregistered/N26673-1949-09-12.md): Taylorcraft BL-65 · S/N 2015 · Cancelled Sep 12, 1949 · Robertson, MO
- [N73685](https://openairdocs.org/deregistered/N73685-1949-02-16.md): Cessna AT-17 · S/N 1996 · Cancelled Feb 16, 1949 · St Louis, MO
- [N36607](https://openairdocs.org/deregistered/N36607-1949-01-06.md): Aeronca 65-CA · S/N 16961 · Cancelled Jan 6, 1949 · Built 1941 · Robertson, MO
- [N47196](https://openairdocs.org/deregistered/N47196-1948-11-01.md): Taylorcraft DCO-65 · S/N L-5508 · Cancelled Nov 1, 1948
- [N20982](https://openairdocs.org/deregistered/N20982-1948-05-28.md): Culver LCA · S/N 111 · Cancelled May 28, 1948 · Robertson, MO
- [N16033](https://openairdocs.org/deregistered/N16033-1948-04-21.md): Ryan Aeronautical ST-A · S/N 122 · Cancelled Apr 21, 1948 · Built 1936 · Robertson, MO
- [N928W](https://openairdocs.org/deregistered/N928W-1948-03-31.md): Stinson SM-8A · S/N M-4105 · Cancelled Mar 31, 1948 · Robertson, MO
- [N694M](https://openairdocs.org/deregistered/N694M-1948-03-11.md): Brewster FLEET 2 · S/N 255 · Cancelled Mar 11, 1948 · Built 1930 · Robertson, MO
- [N14082](https://openairdocs.org/deregistered/N14082-1944-12-21.md): Waco YMF · S/N 4120 · Cancelled Dec 21, 1944 · Built 1934 · Robertson, MO
- [N21688](https://openairdocs.org/deregistered/N21688-1941-04-09.md): Piper J3F-50 · S/N 2574 · Cancelled Apr 9, 1941 · Built 1938 · Robertson, MO
- [N295H](https://openairdocs.org/deregistered/N295H-1940-07-01.md): Curtiss Wright FLEDGLING · S/N B-46 · Cancelled Jul 1, 1940
- [N958](https://openairdocs.org/deregistered/N958-1929-12-30.md): Ryan B1 · S/N 37 · Cancelled Dec 30, 1929 · Anglum, MI
- [N1121](https://openairdocs.org/deregistered/N1121-1928-06-23.md): US Air Mail Services LAND PLANE · S/N 353 · Cancelled Jun 23, 1928 · Built 1925 · Anglum, MO
- [N126](https://openairdocs.org/deregistered/N126-1928-03-07.md): U S Air Mail Service DH 4B LAND PLANE · S/N UNKNOWN · Cancelled Mar 7, 1928 · Anglum, MO
- [N125](https://openairdocs.org/deregistered/N125-1927-10-27.md): Dehavilland DH-4B · S/N 110 · Cancelled Oct 27, 1927 · Anglum, MO
- [N1126](https://openairdocs.org/deregistered/N1126-1927-04-08.md): U S Air Mail Service DH 4B LAND PLANE · S/N 1126 · Cancelled Apr 8, 1927 · Anglum, MO
- [N3427](https://openairdocs.org/deregistered/N3427-undated.md): U S Air Mail Service DH 4B LAND PLANE · S/N 387 · Cancellation date not recorded
- [N7829B](https://openairdocs.org/deregistered/N7829B-undated.md): Robertson M-287 RAINBOW · S/N 1 · Cancellation date not recorded · Fort Worth, TX

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

This list as a web page: https://openairdocs.org/faa-owner/ROBERTSON%20AIRCRAFT%20CORP/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
