# Earlier aircraft under this name: Sugihara Shigeyoshi

A list on [Sugihara Shigeyoshi](https://openairdocs.org/faa-owner/SUGIHARA%20SHIGEYOSHI.md).

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

- [N9527Q](https://openairdocs.org/deregistered/N9527Q-1971-12-22.md): Beech 65 · S/N LC-239 · Cancelled Dec 22, 1971 · Scarsdale, NY
- [N9104Q](https://openairdocs.org/deregistered/N9104Q-1971-03-26.md): Beech 58 · S/N TH-104 · Cancelled Mar 26, 1971 · Exported to Japan · Scarsdale, NY
- [N9115Q](https://openairdocs.org/deregistered/N9115Q-1971-03-03.md): Beech A24R · S/N MC-57 · Cancelled Mar 3, 1971 · Exported to Japan · Scarsdale, NY
- [N4194A](https://openairdocs.org/deregistered/N4194A-1970-04-20.md): Beech 95-B55 (T42A) · S/N TC-1330 · Cancelled Apr 20, 1970 · Exported to Thailand · Scarsdale, NY
- [N8078R](https://openairdocs.org/deregistered/N8078R-1969-06-24.md): Beech 36 · S/N E-156 · Cancelled Jun 24, 1969 · Exported to Japan · Built 1969 · Scarsdale, NY
- [N7756R](https://openairdocs.org/deregistered/N7756R-1969-05-19.md): Beech A65 · S/N LC-324 · Cancelled May 19, 1969 · Exported to Japan · Scarsdale, NY
- [N8004R](https://openairdocs.org/deregistered/N8004R-1969-05-13.md): Beech 56TC · S/N TG 77 · Cancelled May 13, 1969 · Exported to Japan · Scaresdale, NY
- [N7536N](https://openairdocs.org/deregistered/N7536N-1968-12-13.md): Beech E33 · S/N CD-1189 · Cancelled Dec 13, 1968 · Exported to Japan · Scarsdale, NY
- [N7533N](https://openairdocs.org/deregistered/N7533N-1968-11-26.md): Beech E33 · S/N CD-1187 · Cancelled Nov 26, 1968 · Exported to Japan · Scarsdale, NY
- [N7532N](https://openairdocs.org/deregistered/N7532N-1968-11-25.md): Beech E33 · S/N CD-1186 · Cancelled Nov 25, 1968 · Exported to Japan · Scarsdale, NY
- [N7534N](https://openairdocs.org/deregistered/N7534N-1968-11-25.md): Beech E33 · S/N CD-1188 · Cancelled Nov 25, 1968 · Exported to Japan · Scarsdale, NY
- [N7752R](https://openairdocs.org/deregistered/N7752R-1968-05-19.md): Beech A65 · S/N LC-320 · Cancelled May 19, 1968 · Exported to Japan · Scarsdale, NY
- [N7753R](https://openairdocs.org/deregistered/N7753R-1968-05-19.md): Beech A65 · S/N LC321 · Cancelled May 19, 1968 · Exported to Japan · Scarsdale, NY
- [N7754R](https://openairdocs.org/deregistered/N7754R-1968-05-19.md): Beech A65 · S/N LC-322 · Cancelled May 19, 1968 · Exported to Japan · Scarsdale, NY
- [N7755R](https://openairdocs.org/deregistered/N7755R-1968-05-09.md): Beech A65 · S/N LC-323 · Cancelled May 9, 1968 · Exported to Japan · Scarsdale, NY
- [N3743Q](https://openairdocs.org/deregistered/N3743Q-1967-06-29.md): Beech 35-C33 · S/N CD1070 · Cancelled Jun 29, 1967 · Exported to Japan
- [N5861J](https://openairdocs.org/deregistered/N5861J-1965-07-21.md): Beech 65 · S/N LC-161 · Cancelled Jul 21, 1965 · Exported to Japan · Scarsdale, NY
- [N5862J](https://openairdocs.org/deregistered/N5862J-1965-07-21.md): Beech 65 · S/N LC-162 · Cancelled Jul 21, 1965 · Exported to Japan · Scarsdale, NY
- [N6820Q](https://openairdocs.org/deregistered/N6820Q-1964-09-23.md): Beech 65 · S/N LC-157 · Cancelled Sep 23, 1964 · Exported to Japan · Built 1964 · Scarsdale, NY
- [N6821Q](https://openairdocs.org/deregistered/N6821Q-1964-09-23.md): Beech 65 · S/N LC-158 · Cancelled Sep 23, 1964 · Exported to Japan · Built 1964 · Scarsdale, NY
- [N6822Q](https://openairdocs.org/deregistered/N6822Q-1964-09-23.md): Beech 65 · S/N LC-159 · Cancelled Sep 23, 1964 · Exported to Japan · Built 1964 · Scarsdale, NY

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

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