# Registered aircraft: Lemoore, CA

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

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

- [N1223Q](https://openairdocs.org/aircraft/N1223Q.md): Cessna 150L · S/N 15072523 · Built 1971 · Albertson Alford L
- [N1547U](https://openairdocs.org/aircraft/N1547U.md): Air Tractor AT-502A · S/N 502A-0183 · Built 1992 · R & D Leasing Inc
- [N1772J](https://openairdocs.org/aircraft/N1772J.md): Piper PA-28-140 · S/N 28-24194 · Built 1968 · Cope Parrish B
- [N18598](https://openairdocs.org/aircraft/N18598.md): Cessna 150L · S/N 15073974 · Built 1972 · Gudgel Aviation
- [N2071Y](https://openairdocs.org/aircraft/N2071Y.md): Raytheon A36 · S/N E-3120 · Built 1997 · Rossiter Brahm J
- [N2241S](https://openairdocs.org/aircraft/N2241S.md): Cessna 210L · S/N 21061186 · Built 1976 · Edmondson James K
- [N22954](https://openairdocs.org/aircraft/N22954.md): Copenhaver Melvin G RV-4 · S/N 2985 · Built 1994 · Wiermaa Jordan T
- [N252PL](https://openairdocs.org/aircraft/N252PL.md): Mooney M20K · S/N 25-1077 · Built 1986 · Ochoa Preston J
- [N2699W](https://openairdocs.org/aircraft/N2699W.md): Mooney M20E · S/N 1012 · Kingman Connor Joseph
- [N2841N](https://openairdocs.org/aircraft/N2841N.md): DJI AGRAS T30 · S/N 527BK9P001007J · Blair Air Services Inc
- [N2843P](https://openairdocs.org/aircraft/N2843P.md): DJI AGRAS T30 · S/N 527BK87001005P · Blair Air Services Inc
- [N2966B](https://openairdocs.org/aircraft/N2966B.md): DJI AGRAS T30 · S/N 527BK4Q0010092 · Blair Air Service Inc
- [N3178L](https://openairdocs.org/aircraft/N3178L.md): Siai-Marchetti SM 1019 · S/N 039 · Built 1975 · Blair Air Service Inc
- [N35BA](https://openairdocs.org/aircraft/N35BA.md): Beech C90 · S/N LJ-909 · Built 1980 · C90 Air Inc
- [N400KU](https://openairdocs.org/aircraft/N400KU.md): Beech G18S · S/N BA-572 · Built 1961 · Gudgel Daniel R
- [N410AA](https://openairdocs.org/aircraft/N410AA.md): DJI AGRAS T40 · S/N 1581F574B2354001005D · Aerotech Field Solutions LLC
- [N4391Z](https://openairdocs.org/aircraft/N4391Z.md): Piper PA-18-150 · S/N 18-8720 · Built 1968 · Ashby Scott J
- [N45240](https://openairdocs.org/aircraft/N45240.md): Gulfstream American AA-5B · S/N AA5B1112 · Built 1979 · Buford Thomas Edwin
- [N471RN](https://openairdocs.org/aircraft/N471RN.md): Bell OH-58C · S/N 72-21199 · Built 2008 · Blair Helicopter Service Inc
- [N4914Q](https://openairdocs.org/aircraft/N4914Q.md): Cessna A188B · S/N 18802649 · Built 1976 · Gudgel Daniel R
- [N499QA](https://openairdocs.org/aircraft/N499QA.md): Ea Vision EA J100 · S/N EAVUAV502586299 · Agrivantage Drone Solutions LLC
- [N499UA](https://openairdocs.org/aircraft/N499UA.md): Ea Vision EA J100 · S/N EAVUAV502586202 · Agrivantage Drone Solutions LLC
- [N5123U](https://openairdocs.org/aircraft/N5123U.md): Air Tractor AT-802A · S/N 802A-0053 · Built 1997 · R & D Leasing Inc
- [N52119](https://openairdocs.org/aircraft/N52119.md): Cessna 172P · S/N 17274418 · Big E LLC
- [N5747X](https://openairdocs.org/aircraft/N5747X.md): Bell 206B · S/N 3046 · Built 1980 · Blair Air Service Inc
- [N5800K](https://openairdocs.org/aircraft/N5800K.md): Bell OH-58A · S/N 71-20843 · Blair Helicopter Service Inc
- [N595AF](https://openairdocs.org/aircraft/N595AF.md): Bell OH-58C · S/N 71-20749 · Built 1971 · Blair Helicopter Service Inc
- [N602WC](https://openairdocs.org/aircraft/N602WC.md): San Joaquin Helicopters OH-58C · S/N 70-15633 · Built 1970 · Blair Helicopter Service Inc
- [N6126U](https://openairdocs.org/aircraft/N6126U.md): Air Tractor AT-502A · S/N 502A-0298 · Built 1995 · R & D Leasing Inc
- [N6154F](https://openairdocs.org/aircraft/N6154F.md): Gledhill Erik SPRINT II · S/N SPRINT II 500 · Schuh William
- [N67374](https://openairdocs.org/aircraft/N67374.md): Bell 206B · S/N 5146 · Built 1994 · Blair Air Service Inc
- [N67872](https://openairdocs.org/aircraft/N67872.md): Bell 206B · S/N 5217 · Built 1995 · Blair Air Service Inc
- [N7374D](https://openairdocs.org/aircraft/N7374D.md): Cessna 172N · S/N 17272918 · Built 1979 · Big E LLC
- [N761XY](https://openairdocs.org/aircraft/N761XY.md): Cessna T210M · S/N 21062612 · Built 1978 · Ashby Scott J
- [N8377N](https://openairdocs.org/aircraft/N8377N.md): Beech E33A · S/N CE-214 · Built 1968 · Gudgel Daniel R DBA
- [N839H](https://openairdocs.org/aircraft/N839H.md): Hughes 269C · S/N 1090839 · Built 1975 · Blair Helicopter Service Inc
- [N8512F](https://openairdocs.org/aircraft/N8512F.md): Air Tractor AT-802A · S/N 802A-0215 · R & D Leasing Inc
- [N8586S](https://openairdocs.org/aircraft/N8586S.md): Air Tractor AT-301 · S/N 301-0152 · Built 1978 · R & D Leasing Inc
- [N861CC](https://openairdocs.org/aircraft/N861CC.md): Bell OH-58A · S/N 71-20861 · Built 2013 · Blair Helicopter Service
- [N862DZ](https://openairdocs.org/aircraft/N862DZ.md): Bell OH-58A · S/N 70-15357 · Blair Helicopter Service Inc
- [N901PD](https://openairdocs.org/aircraft/N901PD.md): Bell OH-58A · S/N 72-21124 · Built 1972 · Blair Helicopter Service Inc
- [N9043T](https://openairdocs.org/aircraft/N9043T.md): Continental Copters TOMCAT MK5A · S/N CCI74-10 · Built 1975 · Blair Helicopter Service Inc
- [N92486](https://openairdocs.org/aircraft/N92486.md): Cessna 182N · S/N 18260227 · Built 1970 · Big E LLC
- [N9408N](https://openairdocs.org/aircraft/N9408N.md): Piper PA-28R-200 · S/N 28R-35120 · Built 1969 · Cope Parrish B

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

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