# Registered aircraft: Brawley, CA

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

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

- [N124BL](https://openairdocs.org/aircraft/N124BL.md): Cessna 525B · S/N 525B0181 · Built 2007 · Lofton Robert A
- [N157RJ](https://openairdocs.org/aircraft/N157RJ.md): Piper PA-28-236 · S/N 28-7911168 · Built 1979 · Tdt Ag Support LLC
- [N182SG](https://openairdocs.org/aircraft/N182SG.md): Cessna 182P · S/N 18261617 · Built 1972 · Farm Recharge LLC
- [N2047B](https://openairdocs.org/aircraft/N2047B.md): Beech A36 · S/N E-1394 · Built 1978 · Field Inspection LLC
- [N2531U](https://openairdocs.org/aircraft/N2531U.md): Beech A36 · S/N E-2301 · Clyde Shields Entomological Service
- [N25543](https://openairdocs.org/aircraft/N25543.md): Porterfield CP-55 · S/N 664 · Registration revoked · Built 1940 · Harvey John D
- [N27834](https://openairdocs.org/aircraft/N27834.md): Piper J4A · S/N 4-1052 · Built 1940 · Smith Ronald M
- [N284D](https://openairdocs.org/aircraft/N284D.md): Beech A36 · S/N E-1303 · Built 1978 · Reeves Stephen Trustee
- [N3114E](https://openairdocs.org/aircraft/N3114E.md): Aeronca 7AC · S/N 7AC6711 · Built 1946 · Smith Ronald M
- [N3446K](https://openairdocs.org/aircraft/N3446K.md): Piper J3C-65 · S/N 22137 · Densburen Farms Inc
- [N344WB](https://openairdocs.org/aircraft/N344WB.md): Beechcraft B200GT · S/N BY-222 · Built 2014 · Brandt Transport LLC
- [N4323K](https://openairdocs.org/aircraft/N4323K.md): Ryan NAVION · S/N NAV-4-1323 · Built 1948 · Rothfleisch Joseph Ryan
- [N50202](https://openairdocs.org/aircraft/N50202.md): Cessna 150H · S/N 15069132 · Built 1968 · Velasquez Jorge
- [N55575](https://openairdocs.org/aircraft/N55575.md): Boeing A75N1(PT17) · S/N 75-1824 · Built 1946 · Bemis Kenneth L Trustee
- [N55776](https://openairdocs.org/aircraft/N55776.md): Piper PA-32-300 · S/N 32-7340137 · Built 1973 · Jordan John R
- [N5722V](https://openairdocs.org/aircraft/N5722V.md): Beech 35-C33A · S/N CE-36 · Built 1966 · Shank Joel F
- [N6097S](https://openairdocs.org/aircraft/N6097S.md): Beech A36 · S/N E-789 · Built 1975 · Donbee Farms Inc
- [N6589B](https://openairdocs.org/aircraft/N6589B.md): Mooney M20A · S/N 1259 · Built 1958 · Elliott Jason R
- [N6675Y](https://openairdocs.org/aircraft/N6675Y.md): Beech 58P · S/N TJ-254 · Built 1980 · Field Inspection LLC
- [N6797Y](https://openairdocs.org/aircraft/N6797Y.md): Beech A36 · S/N E-2974 · Built 1995 · Far West Ranches Inc
- [N7235](https://openairdocs.org/aircraft/N7235.md): Maule MT-7-235 · S/N 18061C · Built 2001 · Hale Edward S Jr
- [N750PS](https://openairdocs.org/aircraft/N750PS.md): Paul Sanders STOL CH750 · S/N 75-8102 · Built 2017 · Sanders Paul M
- [N7697T](https://openairdocs.org/aircraft/N7697T.md): Cessna 172A · S/N 47297 · Built 1960 · Elliott Jason Rex
- [N7926K](https://openairdocs.org/aircraft/N7926K.md): Beech S35 · S/N D-7421 · Built 1964 · Oconnell Raymond
- [N8008Z](https://openairdocs.org/aircraft/N8008Z.md): Hicks Douglas W TEAM EROS · S/N 1906P · Peterson Blake R
- [N9430S](https://openairdocs.org/aircraft/N9430S.md): Beech 35-C33 · S/N CD-999 · Built 1966 · Smith Ronald M
- [N9499Q](https://openairdocs.org/aircraft/N9499Q.md): Beech A36 · S/N E-323 · Built 1972 · E J K LLC

## 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 = 'BRAWLEY'
ORDER BY g.n_number
```

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