# Registered aircraft: Fairchild 24R-9

A list on [Fairchild 24R-9](https://openairdocs.org/model/fairchild-24r-9.md).

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

- [N1010W](https://openairdocs.org/aircraft/N1010W.md): Lawlor Stephen M · Saint Joseph, MO · Built 1946 · S/N R46-253
- [N1595](https://openairdocs.org/aircraft/N1595.md): Omeara Jeffrey Ryan · Bainbridge Island, WA · Built 1939 · S/N R9-427
- [N18652](https://openairdocs.org/aircraft/N18652.md): Butler County Warbirds Inc · Middletown, OH · Built 1952 · S/N R9-422
- [N18682](https://openairdocs.org/aircraft/N18682.md): Collins John P · El Cajon, CA · Built 1939 · S/N R9-424
- [N20619](https://openairdocs.org/aircraft/N20619.md): Smith Happy E · Rogersville, TN · Built 1939 · S/N 300
- [N20628](https://openairdocs.org/aircraft/N20628.md): Lipsett Rory · Lancaster, PA · Built 1939 · S/N R9-403
- [N20632](https://openairdocs.org/aircraft/N20632.md): Hagerstown Aviation Museum Inc · Hagerstown, MD · Built 1939 · S/N R9-405
- [N2302](https://openairdocs.org/aircraft/N2302.md): Schmidt Aaron B · Auburn, AL · Built 1939 · S/N 304
- [N306W](https://openairdocs.org/aircraft/N306W.md): Allen Cheryl L · Hilltop Lakes, TX · Built 1939 · S/N R9-407

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

This list as a web page: https://openairdocs.org/model/fairchild-24r-9/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.