# Registered aircraft: Socata TAMPICO TB 9C

A list on [Socata TAMPICO TB 9C](https://openairdocs.org/model/socata-tampico-tb-9c.md).

Aircraft of this model in the FAA registry, by N-number.

- [N25278](https://openairdocs.org/aircraft/N25278.md): Winterton Phillip C · Tucson, AZ · S/N 1001
- [N25315](https://openairdocs.org/aircraft/N25315.md): Ifr Inc · San Juan, PR · S/N 1003
- [N2800W](https://openairdocs.org/aircraft/N2800W.md): Azul Aviation Inc · Fort Worth, TX · S/N 1029
- [N2808U](https://openairdocs.org/aircraft/N2808U.md): Coastal Flight Inc · Half Moon Bay, CA · S/N 1056
- [N28199](https://openairdocs.org/aircraft/N28199.md): Guppy Aviation LLC · New Smyrna Beach, FL · Built 1990 · S/N 1062
- [N28216](https://openairdocs.org/aircraft/N28216.md): Ocampo Jose · Montgomery Village, MD · Built 1990 · S/N 1063
- [N2823V](https://openairdocs.org/aircraft/N2823V.md): Onofre-Trejo Ray · Chicago, IL · S/N 1151
- [N30351](https://openairdocs.org/aircraft/N30351.md): Board David N · Woodsfield, OH · First renewal notice · Built 1992 · S/N 1460
- [N3040X](https://openairdocs.org/aircraft/N3040X.md): Kamrath Jeffrey E · Forrest, IL · S/N 1503
- [N3055E](https://openairdocs.org/aircraft/N3055E.md): Fisher Joseph · Canadian, TX · S/N 1579
- [N504PC](https://openairdocs.org/aircraft/N504PC.md): Registered aircraft · S/N 1461
- [N506PC](https://openairdocs.org/aircraft/N506PC.md): Shettlesworth Ryan C · Bloomington, IN · Built 1992 · S/N 1465
- [N507PC](https://openairdocs.org/aircraft/N507PC.md): Viox Alexander · Cleves, OH · S/N 1466
- [N541PC](https://openairdocs.org/aircraft/N541PC.md): Legacy Staining LLC · Monroe, GA · S/N 1563
- [N543PC](https://openairdocs.org/aircraft/N543PC.md): Miller Eric T · Binghamton, NY · S/N 1577
- [N957WA](https://openairdocs.org/aircraft/N957WA.md): Luy Wayman A · Weston, FL · Built 1990 · S/N 1057

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('8680693')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/model/socata-tampico-tb-9c/aircraft

---
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.