OpenAirDocs.org
Cross Anchor, SC

Cancelled registrations · 22

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_state = 'SC' AND d.registrant_city = 'CROSS ANCHOR'
  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 · John Roberts LtdN68862Helio H-295 · S/N 1468Cancelled Feb 8, 1978 · Exported to Ecuador · John Roberts LtdN68886Helio HT-295 · S/N 1716Cancelled Sep 16, 1977 · John Roberts LtdN68880Helio HT-295 · S/N 1711Cancelled Feb 15, 1977 · Exported to South Africa · John Roberts LtdN4469SBeech 58 · S/N TH-639Cancelled Sep 17, 1975 · Exported to South Africa · Built 1975 · John Roberts LtdN7292RBeech 95-B55 (T42A) · S/N TC-1833Cancelled Aug 4, 1975 · Exported to South Africa · John Roberts LtdN68869Helio HT-295 · S/N 1705Cancelled Apr 22, 1975 · Exported to South Africa · John Roberts LtdN7238RBeech 58 · S/N TH-562Cancelled Mar 13, 1975 · Exported to South Africa · John Roberts LtdN6488VHelio H-295 · S/N 1455Cancelled Feb 19, 1975 · Exported to Ecuador · John Roberts LtdN25750Beech 58 · S/N TH-303Cancelled Jan 24, 1975 · Exported to South Africa · John Roberts LtdN68876Helio HT-295 · S/N 1708Cancelled Nov 1, 1974 · Exported to Mexico · John Roberts LtdN68867Helio H-295 · S/N 1472Cancelled Sep 23, 1974 · Exported to Brazil · John Roberts LtdN6495VHelio H-295 · S/N 1460Cancelled May 17, 1974 · Exported to Brazil · John Roberts LtdN6498VHelio HT-295 · S/N 1701Cancelled May 17, 1974 · Exported to Brazil · John Robert LtdN4481WBeech E-55 · S/N TE-977Cancelled May 15, 1974 · Exported to South Africa · Built 1974 · John Roberts LtdN3141WBeech V35B · S/N D-9567Cancelled Apr 25, 1974 · Exported to South Africa · John Roberts LtdN6492VHelio H-295 · S/N 1457Cancelled Apr 19, 1974 · Exported to Brazil · John Roberts LtdN6494VHelio H-295 · S/N 1459Cancelled Apr 9, 1974 · Exported to South Africa · John Roberts LtdN25701Beech 58 · S/N TH-384Cancelled Nov 20, 1973 · Exported to South Africa · Built 1973 · John Roberts LtdN25687Beech 58 · S/N TH-378Cancelled Oct 26, 1973 · Exported to South Africa · John Roberts LtdN1851WBeech 95-B55 · S/N TC-1568Cancelled Oct 4, 1973 · Exported to South Africa · John Roberts LtdN3025WBeech A36 · S/N E-462Cancelled Oct 4, 1973 · Exported to South Africa · John Roberts Ltd
Back to Cross Anchor, SC