# Earlier aircraft under this name: John Roberts Ltd

A list on [John Roberts Ltd](https://openairdocs.org/faa-owner/JOHN%20ROBERTS%20LTD.md).

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

- [N2706J](https://openairdocs.org/deregistered/N2706J-1978-11-24.md): Fairchild F-27J · S/N 117 · Cancelled Nov 24, 1978 · Exported to French Polynesia · Cross Anchor, SC
- [N68862](https://openairdocs.org/deregistered/N68862-1978-02-08.md): Helio H-295 · S/N 1468 · Cancelled Feb 8, 1978 · Exported to Ecuador · Cross Anchor, SC
- [N68886](https://openairdocs.org/deregistered/N68886-1977-09-16.md): Helio HT-295 · S/N 1716 · Cancelled Sep 16, 1977 · Cross Anchor, SC
- [N68880](https://openairdocs.org/deregistered/N68880-1977-02-15.md): Helio HT-295 · S/N 1711 · Cancelled Feb 15, 1977 · Exported to South Africa · Cross Anchor, SC
- [N4469S](https://openairdocs.org/deregistered/N4469S-1975-09-17.md): Beech 58 · S/N TH-639 · Cancelled Sep 17, 1975 · Exported to South Africa · Built 1975 · Cross Anchor, SC
- [N7292R](https://openairdocs.org/deregistered/N7292R-1975-08-04.md): Beech 95-B55 (T42A) · S/N TC-1833 · Cancelled Aug 4, 1975 · Exported to South Africa · Cross Anchor, SC
- [N68869](https://openairdocs.org/deregistered/N68869-1975-04-22.md): Helio HT-295 · S/N 1705 · Cancelled Apr 22, 1975 · Exported to South Africa · Cross Anchor, SC
- [N7238R](https://openairdocs.org/deregistered/N7238R-1975-03-13.md): Beech 58 · S/N TH-562 · Cancelled Mar 13, 1975 · Exported to South Africa · Cross Anchor, SC
- [N6488V](https://openairdocs.org/deregistered/N6488V-1975-02-19.md): Helio H-295 · S/N 1455 · Cancelled Feb 19, 1975 · Exported to Ecuador · Cross Anchor, SC
- [N25750](https://openairdocs.org/deregistered/N25750-1975-01-24.md): Beech 58 · S/N TH-303 · Cancelled Jan 24, 1975 · Exported to South Africa · Cross Anchor, SC
- [N68876](https://openairdocs.org/deregistered/N68876-1974-11-01.md): Helio HT-295 · S/N 1708 · Cancelled Nov 1, 1974 · Exported to Mexico · Cross Anchor, SC
- [N68867](https://openairdocs.org/deregistered/N68867-1974-09-23.md): Helio H-295 · S/N 1472 · Cancelled Sep 23, 1974 · Exported to Brazil · Cross Anchor, SC
- [N6495V](https://openairdocs.org/deregistered/N6495V-1974-05-17.md): Helio H-295 · S/N 1460 · Cancelled May 17, 1974 · Exported to Brazil · Cross Anchor, SC
- [N4481W](https://openairdocs.org/deregistered/N4481W-1974-05-15.md): Beech E-55 · S/N TE-977 · Cancelled May 15, 1974 · Exported to South Africa · Built 1974 · Cross Anchor, SC
- [N3141W](https://openairdocs.org/deregistered/N3141W-1974-04-25.md): Beech V35B · S/N D-9567 · Cancelled Apr 25, 1974 · Exported to South Africa · Cross Anchor, SC
- [N6492V](https://openairdocs.org/deregistered/N6492V-1974-04-19.md): Helio H-295 · S/N 1457 · Cancelled Apr 19, 1974 · Exported to Brazil · Cross Anchor, SC
- [N6494V](https://openairdocs.org/deregistered/N6494V-1974-04-09.md): Helio H-295 · S/N 1459 · Cancelled Apr 9, 1974 · Exported to South Africa · Cross Anchor, SC
- [N25701](https://openairdocs.org/deregistered/N25701-1973-11-20.md): Beech 58 · S/N TH-384 · Cancelled Nov 20, 1973 · Exported to South Africa · Built 1973 · Cross Anchor, SC
- [N25687](https://openairdocs.org/deregistered/N25687-1973-10-26.md): Beech 58 · S/N TH-378 · Cancelled Oct 26, 1973 · Exported to South Africa · Cross Anchor, SC
- [N1851W](https://openairdocs.org/deregistered/N1851W-1973-10-04.md): Beech 95-B55 · S/N TC-1568 · Cancelled Oct 4, 1973 · Exported to South Africa · Cross Anchor, SC
- [N3025W](https://openairdocs.org/deregistered/N3025W-1973-10-04.md): Beech A36 · S/N E-462 · Cancelled Oct 4, 1973 · Exported to South Africa · Cross Anchor, SC

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

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