# Registered aircraft: Standard J-1

A list on [Standard J-1](https://openairdocs.org/model/standard-j-1.md).

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

- [N214J](https://openairdocs.org/aircraft/N214J.md): Nichols Charles F Trustee · Baldwin Park, CA · S/N 214
- [N22581](https://openairdocs.org/aircraft/N22581.md): Owls Head Transportation Museum · Owls Head, ME · Built 1918 · S/N 581
- [N2825D](https://openairdocs.org/aircraft/N2825D.md): Weeks Kermit A · Polk City, FL · Built 1955 · S/N 1582
- [N4213](https://openairdocs.org/aircraft/N4213.md): Western Antique Aeroplane & Automobile Museum · Hood River, OR · S/N 4674
- [N5254](https://openairdocs.org/aircraft/N5254.md): Bowe Walter C Trustee · Sonoma, CA · S/N GFC-31
- [N7063X](https://openairdocs.org/aircraft/N7063X.md): Hammond James F · Yellow Springs, OH · S/N 1000

## 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 ('0761549', '0761579', '05904LV', '0761580')
ORDER BY n_number
```

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