# Earlier aircraft under this name: Crow Inc

A list on [Crow Inc](https://openairdocs.org/faa-owner/CROW%20INC.md).

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

- [N27243](https://openairdocs.org/deregistered/N27243-1978-08-14.md): Piper PA-31-350 · S/N 31-7752119 · Cancelled Aug 14, 1978 · Exported to Canada · Swanton, OH
- [N2498Q](https://openairdocs.org/deregistered/N2498Q-1978-07-13.md): Piper PA-28-140 · S/N 28-7725196 · Cancelled Jul 13, 1978 · Exported to Canada · Swanton, OH
- [N5F](https://openairdocs.org/deregistered/N5F-1976-05-24.md): Piper PA-34-200 · S/N 347350267 · Cancelled May 24, 1976 · Swanton, OH
- [N4381X](https://openairdocs.org/deregistered/N4381X-1976-04-08.md): Piper PA-28-140 · S/N 287625025 · Cancelled Apr 8, 1976 · Exported to Canada · Built 1975 · Swanton, OH
- [N144X](https://openairdocs.org/deregistered/N144X-1975-05-06.md): Aero Commander 520 · S/N 520-48 · Cancelled May 6, 1975 · Swanton, OH
- [N4377P](https://openairdocs.org/deregistered/N4377P-1974-08-05.md): Piper PA-23-160 · S/N 23-1882 · Cancelled Aug 5, 1974 · Built 1949 · North Benton, OH
- [N4252R](https://openairdocs.org/deregistered/N4252R-1973-07-05.md): Piper PA-32S-300 · S/N 32S-40638 · Cancelled Jul 5, 1973 · Exported to New Zealand · Swanton, OH
- [N8083Y](https://openairdocs.org/deregistered/N8083Y-1972-02-16.md): Piper PA-30 · S/N 30-1198 · Cancelled Feb 16, 1972 · Swanton, OH
- [N8425P](https://openairdocs.org/deregistered/N8425P-1971-03-01.md): Piper PA-24-400 · S/N 26-14 · Cancelled Mar 1, 1971 · Swanton, OH
- [N1890J](https://openairdocs.org/deregistered/N1890J-1971-02-26.md): Piper PA-28-140 · S/N 28-24335 · Cancelled Feb 26, 1971 · Built 1968 · Swanton, OH
- [N1819J](https://openairdocs.org/deregistered/N1819J-1971-01-12.md): Piper PA-28-140 · S/N 28-24249 · Cancelled Jan 12, 1971 · Swanton, OH
- [N5376L](https://openairdocs.org/deregistered/N5376L-1970-06-29.md): Piper PA-28-180 · S/N 28-4682 · Cancelled Jun 29, 1970 · Swanton, OH
- [N6171X](https://openairdocs.org/deregistered/N6171X-1969-07-08.md): Aero Commander 680-F · S/N 680F-958-22 · Cancelled Jul 8, 1969 · Exported to Chile · Swanton, OH
- [N7680Y](https://openairdocs.org/deregistered/N7680Y-1968-10-23.md): Piper PA-30 · S/N 30-758 · Cancelled Oct 23, 1968 · Exported to Canada · Swanton, OH
- [N5876Y](https://openairdocs.org/deregistered/N5876Y-1968-10-14.md): Piper PA-23-250 · S/N 27-3028 · Cancelled Oct 14, 1968 · Exported to Canada
- [N5802W](https://openairdocs.org/deregistered/N5802W-1968-07-09.md): Piper PA-28-160 · S/N 28-1868 · Cancelled Jul 9, 1968
- [N7466R](https://openairdocs.org/deregistered/N7466R-1968-07-09.md): Piper PA-28-140 · S/N 28-22014 · Cancelled Jul 9, 1968 · Swanton, OH
- [N5460Z](https://openairdocs.org/deregistered/N5460Z-1965-05-20.md): Piper PA-22-108 · S/N 22-9238 · Cancelled May 20, 1965 · Swanton, OH

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

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