# Earlier aircraft under this name: Aero Spacelines Inc

A list on [Aero Spacelines Inc](https://openairdocs.org/faa-owner/AERO%20SPACELINES%20INC.md).

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

- [N112AS](https://openairdocs.org/deregistered/N112AS-1975-10-09.md): Aero Spacelines 377MGT-1 · S/N 0002 · Cancelled Oct 9, 1975 · Goleta, CA
- [N402Q](https://openairdocs.org/deregistered/N402Q-1973-09-28.md): Boeing 377 · S/N 15974 · Cancelled Sep 28, 1973 · Santa Barbara, CA
- [N403Q](https://openairdocs.org/deregistered/N403Q-1973-09-26.md): Boeing 377 · S/N 15946 · Cancelled Sep 26, 1973 · Santa Barbara, CA
- [N74602](https://openairdocs.org/deregistered/N74602-1973-09-26.md): Boeing 377 · S/N 15948 · Cancelled Sep 26, 1973 · Santa Barbara, CA
- [N212AS](https://openairdocs.org/deregistered/N212AS-1973-08-02.md): Aero Spacelines 377SGT · S/N 0002 · Cancelled Aug 2, 1973 · Exported to France · Santa Barbara, CA
- [N74606](https://openairdocs.org/deregistered/N74606-1972-06-13.md): Boeing 377 · S/N 15952 · Cancelled Jun 13, 1972 · Built 1949 · Santa Barbara, CA
- [N211AS](https://openairdocs.org/deregistered/N211AS-1971-09-24.md): Aero Spacelines 377SGT · S/N 0001 · Cancelled Sep 24, 1971 · Exported to France · Santa Barbara, CA
- [N111AS](https://openairdocs.org/deregistered/N111AS-1970-06-22.md): Aero Spacelines 377MGT-1 · S/N 0001 · Cancelled Jun 22, 1970 · Santa Barbara, CA
- [N401Q](https://openairdocs.org/deregistered/N401Q-1969-09-18.md): Boeing 377 · S/N 15927 · Cancelled Sep 18, 1969 · Built 1949 · Santa Barbara, CA
- [N405Q](https://openairdocs.org/deregistered/N405Q-1969-09-18.md): Boeing 377 · S/N 15975 · Cancelled Sep 18, 1969 · Santa Barbara, CA
- [N406Q](https://openairdocs.org/deregistered/N406Q-1969-09-18.md): Boeing B377PG · S/N 15945 · Cancelled Sep 18, 1969 · Van Nuys, CA
- [N407Q](https://openairdocs.org/deregistered/N407Q-1969-09-18.md): Boeing B377PG · S/N 15976 · Cancelled Sep 18, 1969 · Van Nuys, CA
- [N408Q](https://openairdocs.org/deregistered/N408Q-1969-09-18.md): Boeing B377PG · S/N 15944 · Cancelled Sep 18, 1969 · Van Nuys, CA
- [N74601](https://openairdocs.org/deregistered/N74601-1969-09-18.md): Boeing 377 · S/N 15947 · Cancelled Sep 18, 1969 · Santa Barbara, CA
- [N409Q](https://openairdocs.org/deregistered/N409Q-1964-03-13.md): Boeing 377 · S/N 15977 · Cancelled Mar 13, 1964 · Van Nuys, CA
- [N413Q](https://openairdocs.org/deregistered/N413Q-1964-03-12.md): Boeing B377PG · S/N 15966 · Cancelled Mar 12, 1964 · Built 1959 · Van Nuys, CA

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

This list as a web page: https://openairdocs.org/faa-owner/AERO%20SPACELINES%20INC/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
