# Registered aircraft: North American HARVARD 4

A list on [North American HARVARD 4](https://openairdocs.org/model/north-american-harvard-4.md).

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

- [N1811B](https://openairdocs.org/aircraft/N1811B.md): Onaero Inc · Santa Monica, CA · Built 1952 · S/N 20247
- [N28500](https://openairdocs.org/aircraft/N28500.md): American Aircraft Sales LLC · Livermore, CA · First renewal notice · Built 1946 · S/N 2850
- [N4289C](https://openairdocs.org/aircraft/N4289C.md): Dms Aviation Services LLC · Wildwood, MO · Built 1952 · S/N CCF-4-115
- [N7553U](https://openairdocs.org/aircraft/N7553U.md): Fast Toys For Boys Ltd · Wenatchee, WA · Built 1952 · S/N 20365
- [N7554U](https://openairdocs.org/aircraft/N7554U.md): Staehling Jonathan J · Woodstock, IL · Built 1952 · S/N 20428

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

This list as a web page: https://openairdocs.org/model/north-american-harvard-4/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.