OpenAirDocs.org
John Roberts Ltd

Earlier aircraft under this name · 21

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N2706JFairchild F-27J · S/N 117Cancelled Nov 24, 1978 · Exported to French Polynesia · Cross Anchor, SCN68862Helio H-295 · S/N 1468Cancelled Feb 8, 1978 · Exported to Ecuador · Cross Anchor, SCN68886Helio HT-295 · S/N 1716Cancelled Sep 16, 1977 · Cross Anchor, SCN68880Helio HT-295 · S/N 1711Cancelled Feb 15, 1977 · Exported to South Africa · Cross Anchor, SCN4469SBeech 58 · S/N TH-639Cancelled Sep 17, 1975 · Exported to South Africa · Built 1975 · Cross Anchor, SCN7292RBeech 95-B55 (T42A) · S/N TC-1833Cancelled Aug 4, 1975 · Exported to South Africa · Cross Anchor, SCN68869Helio HT-295 · S/N 1705Cancelled Apr 22, 1975 · Exported to South Africa · Cross Anchor, SCN7238RBeech 58 · S/N TH-562Cancelled Mar 13, 1975 · Exported to South Africa · Cross Anchor, SCN6488VHelio H-295 · S/N 1455Cancelled Feb 19, 1975 · Exported to Ecuador · Cross Anchor, SCN25750Beech 58 · S/N TH-303Cancelled Jan 24, 1975 · Exported to South Africa · Cross Anchor, SCN68876Helio HT-295 · S/N 1708Cancelled Nov 1, 1974 · Exported to Mexico · Cross Anchor, SCN68867Helio H-295 · S/N 1472Cancelled Sep 23, 1974 · Exported to Brazil · Cross Anchor, SCN6495VHelio H-295 · S/N 1460Cancelled May 17, 1974 · Exported to Brazil · Cross Anchor, SCN4481WBeech E-55 · S/N TE-977Cancelled May 15, 1974 · Exported to South Africa · Built 1974 · Cross Anchor, SCN3141WBeech V35B · S/N D-9567Cancelled Apr 25, 1974 · Exported to South Africa · Cross Anchor, SCN6492VHelio H-295 · S/N 1457Cancelled Apr 19, 1974 · Exported to Brazil · Cross Anchor, SCN6494VHelio H-295 · S/N 1459Cancelled Apr 9, 1974 · Exported to South Africa · Cross Anchor, SCN25701Beech 58 · S/N TH-384Cancelled Nov 20, 1973 · Exported to South Africa · Built 1973 · Cross Anchor, SCN25687Beech 58 · S/N TH-378Cancelled Oct 26, 1973 · Exported to South Africa · Cross Anchor, SCN1851WBeech 95-B55 · S/N TC-1568Cancelled Oct 4, 1973 · Exported to South Africa · Cross Anchor, SCN3025WBeech A36 · S/N E-462Cancelled Oct 4, 1973 · Exported to South Africa · Cross Anchor, SC
Back to John Roberts Ltd