Skip to content

Earlier aircraft under this name · 29

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

Query with 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 = 'HUGHES TOOL CO' OR list_contains(d.other_registrant_names, 'HUGHES TOOL CO') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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 = 'HUGHES TOOL CO' OR list_contains(d.other_registrant_names, 'HUGHES TOOL CO')
  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.

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 = 'HUGHES TOOL CO' OR list_contains(d.other_registrant_names, 'HUGHES TOOL CO')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N9945FShort Bros. & Harland SOLENT MARK 3 · S/N S1303Cancelled Jun 9, 1975 · Houston, TX N9947FShort Bros. & Harland SOLENT MARK 3 · S/N NJ 206-S1298Cancelled Jun 9, 1975 · Houston, TX N9523FHughes 269B · S/N 1070340Cancelled Sep 25, 1974 · Culver City, CA N9028FHughes 369HS · S/N 500235SCancelled May 23, 1973 · Exported to Philippines · Culver City, CA N9036FHughes 369HE · S/N 890109ECancelled Jun 29, 1972 · Exported to Brazil · Culver City, CA N9091FHughes 369HS · S/N 610326SCancelled May 17, 1972 · Exported to United Kingdom · Culver City, CA N19540Hughes 269C · S/N 410111Cancelled Apr 21, 1972 · Carlsbad, CA N9051FHughes 369HS · S/N 990125SCancelled Sep 16, 1971 · Exported to Brazil N9072FHughes 369HS · S/N 210294SCancelled Jun 16, 1971 · Exported to Germany N9021FHughes 369HE · S/N 1090207ECancelled Mar 15, 1971 · Exported to Brazil · Culver City, CA N9053FHughes 369HE · S/N 1190212ECancelled Oct 20, 1970 · Exported to Canada N9488FHughes 269B · S/N 270314Cancelled Jun 8, 1970 · Exported to Australia · Culver City, CA N9530FHughes 269B · S/N 680373Cancelled Dec 4, 1968 · Exported to India · Built 1967 · Culver City, CA N9002FHughes 369HM · S/N 480001Cancelled Apr 25, 1968 · Exported to Colombia · Culver City, CA N9003FHughes 369HM · S/N 480002Cancelled Apr 25, 1968 · Exported to Colombia · Culver City, CA N9004FHughes 369HM · S/N 480003Cancelled Apr 25, 1968 · Exported to Colombia · Culver City, CA N9005FHughes 369HM · S/N 480004Cancelled Apr 25, 1968 · Culver City, CA N9502FHughes 269B · S/N 1060265Cancelled Apr 9, 1968 · Culver City, CA N9379FHughes 269B · S/N 0095Cancelled Oct 22, 1965 · Exported to South Korea · Culver City, CA N9698FHughes 369 · S/N 43-0004Cancelled Sep 9, 1965 · Culver City, CA N9699FHughes 369 · S/N 730005Cancelled Sep 9, 1965 · Culver City, CA N9302FHughes 269B · S/N 1130004Cancelled Jun 10, 1965 · Exported to Germany · Culver City, CA N9411FHughes 269B · S/N 0101Cancelled Mar 26, 1965 · Exported to Argentina · Culver City, CA N9697FHughes 369 · S/N 33-0003Cancelled Aug 13, 1964 · Culver City, CA N4958VConsolidated Vultee L-13A · S/N 47-279Cancelled Jun 11, 1964 · Culver City, CA N8787FHughes 269A · S/N 72-0118Cancelled Dec 17, 1963 · Exported to Brazil · Culver City, CA N8785FHughes 269A · S/N 72-0109Cancelled Nov 4, 1963 · Culver City, CA N8740FHughes 269A · S/N 0060Cancelled Jul 1, 1963 · Culver City, CA N5606VDouglas C-47A · S/N 9456Cancelled Feb 27, 1951 · Exported to El Salvador · Culver City, CA

Back to Hughes Tool Co