Earlier aircraft under this name · 28

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 = 'NORTH AMERICAN ROCKWELL CORP' OR list_contains(d.other_registrant_names, 'NORTH AMERICAN ROCKWELL CORP') 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 = 'NORTH AMERICAN ROCKWELL CORP' OR list_contains(d.other_registrant_names, 'NORTH AMERICAN ROCKWELL CORP')
  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 = 'NORTH AMERICAN ROCKWELL CORP' OR list_contains(d.other_registrant_names, 'NORTH AMERICAN ROCKWELL CORP')
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.

N1149JRockwell International 112 · S/N 98Cancelled Jul 23, 1974 · Exported to Brazil N112ARAero Commander 112 · S/N 0004Cancelled Jan 29, 1974 · Albany, GA N1009JAero Commander 112 · S/N 9Cancelled Oct 3, 1973 · Albany, GA N112GAAero Commander 112 · S/N 0005Cancelled Sep 24, 1973 · Built 1973 · Albany, GA N5602XAero Commander 111 · S/N 10002Cancelled Sep 12, 1973 · Albany, GA N9001NAero Commander 690 · S/N 11000Cancelled Jun 7, 1973 · Bethany, OK N9103NAero Commander 500 S · S/N 3135Cancelled Apr 17, 1973 · Exported to Mozambique · Bethany, OK N201FEAero Commander 500 S · S/N 3101Cancelled Jan 26, 1973 · Exported to Jamaica · Built 1970 · Bethany, OK N13681Aero Commander S2R · S/N 1604RCancelled May 30, 1972 · Exported to El Salvador · Albany, GA N7665VAero Commander CALLAIR A-9B · S/N 1393Cancelled Mar 13, 1972 · Exported to Mexico · Albany, GA N8576Aero Commander S2R · S/N 1611RCancelled Mar 8, 1972 · Exported to Venezuela · Albany, GA N8574Aero Commander S2R · S/N 1610RCancelled Mar 6, 1972 · Exported to Portugal · Albany, GA N8572Aero Commander S2R · S/N 1608RCancelled Feb 11, 1972 · Exported to Brazil · Albany, GA N112ACAero Commander 112 · S/N 1Cancelled Nov 16, 1971 · Albany, GA N8916QAero Commander S2R · S/N 1586RCancelled Sep 16, 1971 · Exported to El Salvador · Albany, GA N3747XAero Commander 100-180 · S/N 5058Cancelled Mar 15, 1971 · Exported to Uruguay · Albany, GA N5044EAero Commander 1121B · S/N 136Cancelled Oct 31, 1969 · Exported to Sweden · Bethany, OK N7692VAero Commander CALLAIR A-9B · S/N 1445Cancelled Jul 29, 1969 · Exported to El Salvador · Albany, GA N7702VAero Commander CALLAIR A-9B · S/N 1453Cancelled Jul 29, 1969 · Exported to Colombia · Albany, GA N4691EAero Commander 1121 · S/N 107Cancelled Jun 16, 1969 · Exported to Israel · Bethany, OK N7671VAero Commander CALLAIR A-9B · S/N 1429Cancelled May 12, 1969 · Exported to Nicaragua · Albany, GA N4930EAero Commander 500 S · S/N 1810-20Cancelled Jan 21, 1969 · Exported to Australia · Bethany, OK N7637VAero Commander CALLAIR A-9B · S/N 1365Cancelled Oct 3, 1968 · Exported to Turkey · Albany, GA N3754XAero Commander 100-180 · S/N 5067Cancelled Sep 26, 1968 · Exported to Venezuela · Albany, GA N9488Intermountain CALLAIR B-1 · S/N 10014Cancelled May 9, 1968 · Exported to Turkey · Albany, GA N4530EAero Commander 680FL · S/N 1665-130Cancelled Mar 18, 1968 · Exported to Argentina · Built 1967 · Bethany, OK N112RRAero Commander 112 · S/N 6Cancellation date not recorded · Albany, GA N9115NAero Commander 680FL · S/N 1852-156Cancellation date not recorded · Bethany, OK

Back to North American Rockwell Corp