# Registered aircraft: Sikorsky CH-148

A list on [Sikorsky CH-148](https://openairdocs.org/model/sikorsky-ch-148.md).

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

- [N801CN](https://openairdocs.org/aircraft/N801CN.md): Sikorsky Aircraft Corp · Stratford, CT · Built 2008 · S/N 148801
- [N802CN](https://openairdocs.org/aircraft/N802CN.md): Sikorsky Aircraft Corp · Stratford, CT · Built 2009 · S/N 148802
- [N803CN](https://openairdocs.org/aircraft/N803CN.md): Sikorsky Aircraft Corp · Stratford, CT · Built 2010 · S/N 148803
- [N804CN](https://openairdocs.org/aircraft/N804CN.md): Sikorsky Aircraft Corp · Stratford, CT · S/N 148804

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

This list as a web page: https://openairdocs.org/model/sikorsky-ch-148/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.