# Earlier aircraft under this name: Clearwater Aircraft Inc

A list on [Clearwater Aircraft Inc](https://openairdocs.org/faa-owner/CLEARWATER%20AIRCRAFT%20INC.md).

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

- [N512PC](https://openairdocs.org/deregistered/N512PC-2013-02-15.md): Socata TB 9 TAMPICO · S/N 1545 · Cancelled Feb 15, 2013 · Expired dealer · Clearwater, FL
- [N540PC](https://openairdocs.org/deregistered/N540PC-2013-01-29.md): Socata TB 9 TAMPICO · S/N 1562 · Cancelled Jan 29, 2013 · Expired dealer · Clearwater, FL
- [N542PC](https://openairdocs.org/deregistered/N542PC-2013-01-29.md): Socata TAMPICO TB 9C · S/N 1576 · Cancelled Jan 29, 2013 · Expired dealer · Clearwater, FL
- [N544PC](https://openairdocs.org/deregistered/N544PC-2013-01-29.md): Socata TB 9 TAMPICO · S/N 1643 · Cancelled Jan 29, 2013 · Expired dealer · Clearwater, FL
- [N549PC](https://openairdocs.org/deregistered/N549PC-2013-01-29.md): Socata TB 9 TAMPICO · S/N 1512 · Cancelled Jan 29, 2013 · Expired dealer · Clearwater, FL
- [N9158P](https://openairdocs.org/deregistered/N9158P-2011-10-28.md): Piper PA-28-161 · S/N 2841037 · Cancelled Oct 28, 2011 · Exported to Brazil · Built 1988 · Clearwater, FL
- [N2032N](https://openairdocs.org/deregistered/N2032N-2011-09-08.md): Cessna 172S · S/N 172S9666 · Cancelled Sep 8, 2011 · Exported to Australia · Built 2004 · Clearwater, FL
- [N5082Q](https://openairdocs.org/deregistered/N5082Q-2011-02-24.md): Cessna 152 · S/N 15285067 · Cancelled Feb 24, 2011 · Exported to Brazil · Built 1981 · Clearwater, FL
- [N5091Q](https://openairdocs.org/deregistered/N5091Q-2011-02-24.md): Cessna 152 · S/N 15285072 · Cancelled Feb 24, 2011 · Exported to Brazil · Built 1981 · Clearwater, FL
- [N66113](https://openairdocs.org/deregistered/N66113-2010-11-12.md): Cessna 172S · S/N 172S9782 · Cancelled Nov 12, 2010 · Exported to Australia · Built 2005 · Clearwater, FL
- [N956LP](https://openairdocs.org/deregistered/N956LP-2010-09-03.md): Cessna 172S · S/N 172S9956 · Cancelled Sep 3, 2010 · Exported to New Zealand · Built 2005 · Clearwater, FL
- [N4997G](https://openairdocs.org/deregistered/N4997G-2010-05-12.md): Cessna 414 · S/N 414-0427 · Cancelled May 12, 2010 · Exported to Colombia · Built 1973 · Clearwater, FL
- [N443CR](https://openairdocs.org/deregistered/N443CR-2010-03-22.md): Cessna 172R · S/N 17280661 · Cancelled Mar 22, 2010 · Exported to Thailand · Built 1998 · Clearwater, FL
- [N498CR](https://openairdocs.org/deregistered/N498CR-2010-03-22.md): Cessna 172R · S/N 17280674 · Cancelled Mar 22, 2010 · Exported to Thailand · Built 1998 · Clearwater, FL
- [N1208V](https://openairdocs.org/deregistered/N1208V-2009-08-06.md): Cessna R172K · S/N R1722139 · Cancelled Aug 6, 2009 · Exported to Bolivia · Built 1976 · Clearwater, FL
- [N5516R](https://openairdocs.org/deregistered/N5516R-2008-06-11.md): Cessna 172F · S/N 17253091 · Cancelled Jun 11, 2008 · Exported to Canada · Built 1965 · Clearwater, FL
- [N532PU](https://openairdocs.org/deregistered/N532PU-2008-04-17.md): Piper PA-28R-201 · S/N 2837040 · Cancelled Apr 17, 2008 · Exported to Australia · Built 1989 · Clearwater, FL
- [N223JA](https://openairdocs.org/deregistered/N223JA-2007-06-21.md): Piper PA-28-161 · S/N 28-8016203 · Cancelled Jun 21, 2007 · Exported to Canada · Built 1979 · Clearwater, FL
- [N93DC](https://openairdocs.org/deregistered/N93DC-2006-06-14.md): Piper PA-31-310 · S/N 31-7712017 · Cancelled Jun 14, 2006 · Triennial form not returned · Built 1977 · Clearwater Beach, FL
- [N15399](https://openairdocs.org/deregistered/N15399-1999-02-01.md): Piper PA-34-200 · S/N 34-7350058 · Cancelled Feb 1, 1999 · Exported to Canada · Clearwater, FL

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

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