# Registered aircraft: Corcoran, CA

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

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

- [N243LA](https://openairdocs.org/aircraft/N243LA.md): Air Tractor AT-502B · S/N 502B-3020 · Built 2015 · H & G Farms Inc
- [N305LD](https://openairdocs.org/aircraft/N305LD.md): DJI AGRAS T40 · S/N 64TBK8L0010029 · Lakeland Aviation Inc
- [N359B](https://openairdocs.org/aircraft/N359B.md): Beech H35 · S/N D-5049 · Built 1957 · Felder Charles G
- [N3891T](https://openairdocs.org/aircraft/N3891T.md): Piper PA-28R-180 · S/N 28R-30220 · Built 1967 · Jones Rodney D
- [N40054](https://openairdocs.org/aircraft/N40054.md): Ayres S-2R · S/N 2492R · Built 1978 · Lakeland Dusters Aviation Inc
- [N502LD](https://openairdocs.org/aircraft/N502LD.md): Air Tractor AT-502B · S/N 502B-2905 · Built 2013 · H & G Farms
- [N502X](https://openairdocs.org/aircraft/N502X.md): Air Tractor AT-502B · S/N 502B-3423 · Built 2023 · H&G Farms Inc
- [N521JD](https://openairdocs.org/aircraft/N521JD.md): Cessna 172S · S/N 172S8027 · Built 1998 · H&G Farms Inc
- [N527AT](https://openairdocs.org/aircraft/N527AT.md): Air Tractor AT-502B · S/N 502B-3396 · Built 2022 · H&G Farms Inc
- [N531B](https://openairdocs.org/aircraft/N531B.md): American Eurocopter AS350B2 · S/N 7161 · Jg Boswell Co
- [N541B](https://openairdocs.org/aircraft/N541B.md): Beechcraft B200GT · S/N BY-189 · Built 2013 · J. G. Boswell Co
- [N557CF](https://openairdocs.org/aircraft/N557CF.md): Air Tractor AT-802A · S/N 802A-0668 · Built 2016 · H & G Farms Inc
- [N61373](https://openairdocs.org/aircraft/N61373.md): Ayres S2R-T34 · S/N T34-216 · Built 1996 · H & G Farms Inc
- [N6181D](https://openairdocs.org/aircraft/N6181D.md): Piper PA-18A 150 · S/N 18-5468 · Built 1957 · Nolta Christopher D
- [N76546](https://openairdocs.org/aircraft/N76546.md): Cessna 120 · S/N 10982 · Built 1946 · Frey Kirk D
- [N78NL](https://openairdocs.org/aircraft/N78NL.md): Bell 206B · S/N 1561 · Built 1974 · H&G Farms Inc
- [N88HR](https://openairdocs.org/aircraft/N88HR.md): Raytheon B300 · S/N FL-225 · Built 1998 · Hansen Ranches 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 = 'CORCORAN'
ORDER BY g.n_number
```

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