OpenAirDocs.org
Lemoore, CA

Registered aircraft · 44

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N1223QCessna 150L · S/N 15072523Built 1971 · Albertson Alford LN1547UAir Tractor AT-502A · S/N 502A-0183Built 1992 · R & D Leasing IncN1772JPiper PA-28-140 · S/N 28-24194Built 1968 · Cope Parrish BN18598Cessna 150L · S/N 15073974Built 1972 · Gudgel AviationN2071YRaytheon A36 · S/N E-3120Built 1997 · Rossiter Brahm JN2241SCessna 210L · S/N 21061186Built 1976 · Edmondson James KN22954Copenhaver Melvin G RV-4 · S/N 2985Built 1994 · Wiermaa Jordan TN252PLMooney M20K · S/N 25-1077Built 1986 · Ochoa Preston JN2699WMooney M20E · S/N 1012Kingman Connor JosephN2841NDJI AGRAS T30 · S/N 527BK9P001007JBlair Air Services IncN2843PDJI AGRAS T30 · S/N 527BK87001005PBlair Air Services IncN2966BDJI AGRAS T30 · S/N 527BK4Q0010092Blair Air Service IncN3178LSiai-Marchetti SM 1019 · S/N 039Built 1975 · Blair Air Service IncN35BABeech C90 · S/N LJ-909Built 1980 · C90 Air IncN400KUBeech G18S · S/N BA-572Built 1961 · Gudgel Daniel RN410AADJI AGRAS T40 · S/N 1581F574B2354001005DAerotech Field Solutions LLCN4391ZPiper PA-18-150 · S/N 18-8720Built 1968 · Ashby Scott JN45240Gulfstream American AA-5B · S/N AA5B1112Built 1979 · Buford Thomas EdwinN471RNBell OH-58C · S/N 72-21199Built 2008 · Blair Helicopter Service IncN4914QCessna A188B · S/N 18802649Built 1976 · Gudgel Daniel RN499QAEa Vision EA J100 · S/N EAVUAV502586299Agrivantage Drone Solutions LLCN499UAEa Vision EA J100 · S/N EAVUAV502586202Agrivantage Drone Solutions LLCN5123UAir Tractor AT-802A · S/N 802A-0053Built 1997 · R & D Leasing IncN52119Cessna 172P · S/N 17274418Big E LLCN5747XBell 206B · S/N 3046Built 1980 · Blair Air Service IncN5800KBell OH-58A · S/N 71-20843Blair Helicopter Service IncN595AFBell OH-58C · S/N 71-20749Built 1971 · Blair Helicopter Service IncN602WCSan Joaquin Helicopters OH-58C · S/N 70-15633Built 1970 · Blair Helicopter Service IncN6126UAir Tractor AT-502A · S/N 502A-0298Built 1995 · R & D Leasing IncN6154FGledhill Erik SPRINT II · S/N SPRINT II 500Schuh WilliamN67374Bell 206B · S/N 5146Built 1994 · Blair Air Service IncN67872Bell 206B · S/N 5217Built 1995 · Blair Air Service IncN7374DCessna 172N · S/N 17272918Built 1979 · Big E LLCN761XYCessna T210M · S/N 21062612Built 1978 · Ashby Scott JN8377NBeech E33A · S/N CE-214Built 1968 · Gudgel Daniel R DBAN839HHughes 269C · S/N 1090839Built 1975 · Blair Helicopter Service IncN8512FAir Tractor AT-802A · S/N 802A-0215R & D Leasing IncN8586SAir Tractor AT-301 · S/N 301-0152Built 1978 · R & D Leasing IncN861CCBell OH-58A · S/N 71-20861Built 2013 · Blair Helicopter ServiceN862DZBell OH-58A · S/N 70-15357Blair Helicopter Service IncN901PDBell OH-58A · S/N 72-21124Built 1972 · Blair Helicopter Service IncN9043TContinental Copters TOMCAT MK5A · S/N CCI74-10Built 1975 · Blair Helicopter Service IncN92486Cessna 182N · S/N 18260227Built 1970 · Big E LLCN9408NPiper PA-28R-200 · S/N 28R-35120Built 1969 · Cope Parrish B
Back to Lemoore, CA