# Earlier aircraft under this name: Roberts Aircraft Company

A list on [Roberts Aircraft Company](https://openairdocs.org/faa-owner/ROBERTS%20AIRCRAFT%20COMPANY.md).

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

- [N47294](https://openairdocs.org/deregistered/N47294-2017-07-12.md): Aerospatiale SA315B · S/N 2448 · Cancelled Jul 12, 2017 · Registration expired, pending cancellation · Built 1975 · Cheyenne, WY
- [N3609R](https://openairdocs.org/deregistered/N3609R-2017-06-08.md): S N I A S AS350D ASTAR · S/N 1250 · Cancelled Jun 8, 2017 · Registration expired, pending cancellation · Built 1980 · Granite Canyon, WY
- [N156EH](https://openairdocs.org/deregistered/N156EH-2017-05-15.md): S N I A S AS350D ASTAR · S/N 1185 · Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 1979 · Albany, OR
- [N2696E](https://openairdocs.org/deregistered/N2696E-2014-11-20.md): Hughes 369HS · S/N 240567S · Cancelled Nov 20, 2014 · Registration expired, pending cancellation · Monument, CO
- [N31660](https://openairdocs.org/deregistered/N31660-2014-10-30.md): Aerospatiale SA316B ALOUETTE III · S/N 1481 · Cancelled Oct 30, 2014 · First renewal notice · Built 1967 · Cheyenne, WY
- [N402AH](https://openairdocs.org/deregistered/N402AH-2014-10-30.md): Aerospatiale SA315B · S/N 2484 · Cancelled Oct 30, 2014 · First renewal notice · Cheyenne, WY
- [N707EX](https://openairdocs.org/deregistered/N707EX-2014-09-10.md): Aerospatiale SA315B · S/N 2430 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1976 · Cheyenne, WY
- [N3153R](https://openairdocs.org/deregistered/N3153R-2013-04-09.md): Aerospatiale SA316B ALOUETTE III · S/N 1484 · Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1967 · Albany, OR
- [N1235A](https://openairdocs.org/deregistered/N1235A-2011-09-28.md): Aerospatiale SA316B ALOUETTE III · S/N 1235 · Cancelled Sep 28, 2011 · First renewal notice · Built 1964 · Cheyenne, WY
- [N3154Y](https://openairdocs.org/deregistered/N3154Y-2007-06-15.md): Aerospatiale SA316B ALOUETTE III · S/N 1428 · Cancelled Jun 15, 2007 · Triennial form not returned · Built 1967 · Granite Canyon, WY
- [N49511](https://openairdocs.org/deregistered/N49511-2007-06-12.md): Aerospatiale SA315B · S/N 2485 · Cancelled Jun 12, 2007 · Triennial form not returned · Granite Canyon, WY
- [N49913](https://openairdocs.org/deregistered/N49913-2007-06-12.md): Aerospatiale SA316B ALOUETTE III · S/N 1091 · Cancelled Jun 12, 2007 · Triennial form not returned · Built 1963 · Granite Canyon, WY
- [N37903](https://openairdocs.org/deregistered/N37903-2007-06-08.md): Aerospatiale SA315B · S/N 2565 · Cancelled Jun 8, 2007 · Triennial form not returned · Built 1979 · Granite Canyon, WY
- [N85356](https://openairdocs.org/deregistered/N85356-2007-06-08.md): Aerospatiale SA315B · S/N 2383 · Cancelled Jun 8, 2007 · Triennial form not returned · Built 1974 · Granite Canyon, WY
- [N8656](https://openairdocs.org/deregistered/N8656-2007-06-08.md): Aerospatiale SE3160 ALOUETTE III · S/N 1729 · Cancelled Jun 8, 2007 · Triennial form not returned · Built 1971 · Granite Canyon, WY
- [N482RA](https://openairdocs.org/deregistered/N482RA-2007-05-22.md): Sud SE3160 ALOUETTE III · S/N 1482 · Cancelled May 22, 2007 · Triennial form not returned · Granite Canyon, WY
- [N605RA](https://openairdocs.org/deregistered/N605RA-2007-05-22.md): Aerospatiale SA316B ALOUETTE III · S/N 1165 · Cancelled May 22, 2007 · Triennial form not returned · Built 1964 · Cheyenne, WY
- [N607RM](https://openairdocs.org/deregistered/N607RM-2007-05-22.md): Aerospatiale SA316B ALOUETTE III · S/N 1167 · Cancelled May 22, 2007 · Triennial form not returned · Built 1964 · Granite Canyon, WY
- [N7251P](https://openairdocs.org/deregistered/N7251P-2007-05-22.md): Aerospatiale SE3160 ALOUETTE III · S/N 1398 · Cancelled May 22, 2007 · Triennial form not returned · Granite Canyon, WY
- [N91213](https://openairdocs.org/deregistered/N91213-2007-05-22.md): Aerospatiale SA316B ALOUETTE III · S/N 2159 · Cancelled May 22, 2007 · Second triennial mailing, no response · Granite Canyon, WY
- [N57927](https://openairdocs.org/deregistered/N57927-2005-07-14.md): Aerospatiale AS 355F1 · S/N 5122 · Cancelled Jul 14, 2005 · Exported to Canada · Granite Canyon, WY
- [N5797P](https://openairdocs.org/deregistered/N5797P-2005-07-14.md): Aerospatiale AS 355F1 · S/N 5148 · Cancelled Jul 14, 2005 · Exported to Canada · Granite Canyon, WY
- [N3978Y](https://openairdocs.org/deregistered/N3978Y-2002-09-13.md): Aerospatiale SA315B · S/N 2520 · Cancelled Sep 13, 2002 · Triennial form not returned · Built 1978 · Granite Canyon, WY
- [N9005E](https://openairdocs.org/deregistered/N9005E-1999-07-16.md): Aerospatiale SA315B · S/N 2538 · Cancelled Jul 16, 1999 · Exported to Canada · Albany, OR
- [N348RA](https://openairdocs.org/deregistered/N348RA-1999-04-12.md): Aerospatiale SA315B · S/N 2569 · Cancelled Apr 12, 1999 · Exported to Costa Rica · Albany, OR
- [N345RA](https://openairdocs.org/deregistered/N345RA-1998-10-15.md): Aerospatiale SA315B · S/N 2591 · Cancelled Oct 15, 1998 · Exported to Costa Rica · Albany, OR
- [N180US](https://openairdocs.org/deregistered/N180US-1998-04-29.md): Aerospatiale SA315B · S/N 2631 · Cancelled Apr 29, 1998 · Exported to Bolivia · Albany, OR
- [N27387](https://openairdocs.org/deregistered/N27387-1998-04-14.md): Aerospatiale SA315B · S/N 2625 · Cancelled Apr 14, 1998 · Exported to Germany · Albany, OR
- [N529RA](https://openairdocs.org/deregistered/N529RA-1998-01-27.md): Aerospatiale SA316B ALOUETTE III · S/N 1529 · Cancelled Jan 27, 1998 · Exported to Bolivia · Albany, OR
- [N499RA](https://openairdocs.org/deregistered/N499RA-1997-09-02.md): Aerospatiale SA316B ALOUETTE III · S/N 1499 · Cancelled Sep 2, 1997 · Exported to Venezuela · Albany, OR
- [N31675](https://openairdocs.org/deregistered/N31675-1996-07-18.md): Aerospatiale SA315B · S/N 2611 · Cancelled Jul 18, 1996 · Exported to Hong Kong · Albany, OR

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

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