# Registered aircraft: Romoland, CA

A list on [Romoland, CA](https://openairdocs.org/faa-place/CA/Romoland.md).

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N1057D](https://openairdocs.org/aircraft/N1057D.md): Cessna 195A · S/N 7669 · Medore Douglas A
- [N105EC](https://openairdocs.org/aircraft/N105EC.md): Aerovodochody L-29 DELFIN · S/N 093948 · Built 1970 · Prop & Jet Air Museum
- [N112KG](https://openairdocs.org/aircraft/N112KG.md): Staudacher S-300D2 · S/N 22 · Medore Douglas A
- [N113PC](https://openairdocs.org/aircraft/N113PC.md): Childers M L/Combs P T FOKKER DR 1 · S/N 1 · Built 1982 · Prop & Jet Air Museum Inc
- [N13637](https://openairdocs.org/aircraft/N13637.md): Lightsey Mark CORBEN SUPER ACE · S/N 1935 · Medore Douglas A
- [N20228](https://openairdocs.org/aircraft/N20228.md): Olive John R EAA BIPLANE P2 · S/N 21105052347 · Built 2001 · Howell Tyler
- [N2255X](https://openairdocs.org/aircraft/N2255X.md): Cessna 337 · S/N 337-0155 · Prop & Jet Air Museum Inc
- [N2327Y](https://openairdocs.org/aircraft/N2327Y.md): Yakovlev YAK 52 · S/N 888704 · Built 1988 · Medore Douglas A
- [N236CC](https://openairdocs.org/aircraft/N236CC.md): Calcote Clarence E GLASAIR RG · S/N 295 · Built 1984 · Prop And Jet Air Museum
- [N29KJ](https://openairdocs.org/aircraft/N29KJ.md): Aerovodochody L-29 DELFIN · S/N 491174 · Built 1964 · Medore Doug
- [N3100G](https://openairdocs.org/aircraft/N3100G.md): North American T-6G · S/N 49-3207 · Built 1949 · Medore Douglas A
- [N37DG](https://openairdocs.org/aircraft/N37DG.md): Aerovodochody L-29 DELFIN · S/N 591326 · Built 1965 · Prop And Jet Air Museum Inc
- [N4684L](https://openairdocs.org/aircraft/N4684L.md): Cessna 172G · S/N 17254679 · Built 1966 · Howell Tyler L
- [N4747Q](https://openairdocs.org/aircraft/N4747Q.md): Cessna A185E · S/N 185-1201 · Ross Andrew P
- [N4845M](https://openairdocs.org/aircraft/N4845M.md): Cessna 305C (0-1E) · S/N 24569 · Built 1959 · Medore Douglas A
- [N4SH](https://openairdocs.org/aircraft/N4SH.md): Staudacher Jon S-600 · S/N 19 · Built 1994 · Prop And Jet Air Museum
- [N557DM](https://openairdocs.org/aircraft/N557DM.md): Taylor Geoff BD5J · S/N BS-9 · Built 1993 · Medore Douglas A
- [N56565](https://openairdocs.org/aircraft/N56565.md): Ryan Aeronautical ST3KR · S/N 1431 · Built 1941 · Prop & Jet Air Museum Inc
- [N58368](https://openairdocs.org/aircraft/N58368.md): Piper J3C-65 · S/N 8939 · Built 1942 · Prop & Jet Air Museum
- [N59843](https://openairdocs.org/aircraft/N59843.md): Cons Vultee/Lacey BT-13B · S/N 9244L · Medore Douglas A
- [N62936](https://openairdocs.org/aircraft/N62936.md): Beech D18S · S/N CA38 · Prop And Jet Air Museum
- [N7090L](https://openairdocs.org/aircraft/N7090L.md): Yakovlev YAK-55M · S/N 930807 · Built 1993 · Medore Douglas A
- [N82171](https://openairdocs.org/aircraft/N82171.md): Aerovodochody L-29 DELFIN · S/N 0105 · Built 1962 · Prop And Jet Air Museum
- [N951SG](https://openairdocs.org/aircraft/N951SG.md): John S Todhunter SP-1 · S/N JST-003 · Built 2011 · Prop & Jet Air Museum
- [N99394](https://openairdocs.org/aircraft/N99394.md): North American T-28A · S/N 49-1645A · Medore Douglas A

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
WHERE g.registrant_state = 'CA' AND g.registrant_city = 'ROMOLAND'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/CA/Romoland/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.