# Registered aircraft: Colonial C-1

A list on [Colonial C-1](https://openairdocs.org/model/colonial-c-1.md).

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

- [N24HA](https://openairdocs.org/aircraft/N24HA.md): Hillestad Darrell · Aberdeen, SD · Built 1957 · S/N 24
- [N253B](https://openairdocs.org/aircraft/N253B.md): Lewis Donald L · Brant Lake, NY · Built 1957 · S/N 13
- [N254B](https://openairdocs.org/aircraft/N254B.md): Aas LLC · Ovid, MI · Built 1957 · S/N 14
- [N256B](https://openairdocs.org/aircraft/N256B.md): Slayton Michael B · Grand Haven, MI · Built 1957 · S/N 16
- [N263B](https://openairdocs.org/aircraft/N263B.md): Pederstuen Ricky L · Hudson, WI · Built 1957 · S/N 23
- [N265B](https://openairdocs.org/aircraft/N265B.md): Hillestad Darrell · Aberdeen, SD · S/N 25
- [N6595K](https://openairdocs.org/aircraft/N6595K.md): Mr B Aviation LLC · Sag Harbor, NY · Built 1948 · S/N 1
- [N9439H](https://openairdocs.org/aircraft/N9439H.md): Treichler Peter DBA · East Aurora, NY · Built 1964 · S/N 6

## 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 ('5110102')
ORDER BY n_number
```

This list as a web page: https://openairdocs.org/model/colonial-c-1/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.
