OpenAirDocs.org
Clovis, CA

Registered aircraft · 59

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 = 'CLOVIS'
  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.

N1111STextron 525 · S/N 525-1111Built 2022 · Stockbridge General Contracting IncN1405XPiper PA-28-151 · S/N 28-7515292Built 1975 · Rij EdwardN150FLCessna 150J · S/N 15070938Built 1969 · Berry Jeffrey ThomasN157DLSweet David L RV-6 · S/N 21079Built 2010 · Sweet David LN15MTStahl Edgar M THORP T-18 · S/N 1023Teixeira Matthew RN16101Cessna 150L · S/N 15073477Hatch David GN1701DMooney M20J · S/N 24-1156Built 1981 · Blue Skies Aero LLCN177TAHawker Beechcraft B200GT · S/N BY-2Built 2007 · Harrier Icg LLCN182PACessna T182T · S/N T18208863Built 2008 · Decicco John AnthonyN198JTChampion 7ECA · S/N 1357-95Built 1995 · Ribeiro Brian CN20299Cessna 172M · S/N 17261172Built 1972 · Smiley LLCN231CKMooney M20K · S/N 25-0143Built 1979 · Robertson Stephen W JrN231THMooney M20K · S/N 25-0157Moe Robert P TrusteeN2370VCessna 140 · S/N 14606Built 1948 · Blackburn Russell AN244LMPiper PA 46-350P · S/N 4636531Built 2012 · Sunset Horizons LLCN26893Piper PA-28R-180 · S/N 28R-30679Goodman Harold WayneN301RVCirrus Design SR22 · S/N 1172Built 2004 · K6 Construction IncN3096FCessna 182J · S/N 18257196Built 1966 · Mcdowell Samuel DN311DRSocata TB-20 TRINIDAD · S/N 9557427 Aviation LLCN313WBeech V35B · S/N D-10363Built 1981 · Williams Thomas JamesN325MRPiper PA 46-350P · S/N 4636358Built 2004 · Dv Group LLCN33959Taylorcraft BC12-65 · S/N 2811Andrews Kenneth DN350AEBeechcraft B300 · S/N FL-848Built 2013 · Wcp Developers LLCN37364Interstate S-1A-85F · S/N 207Built 1941 · Moehlman Nathan PN381CRBeech A36 · S/N E-875Built 1976 · Siemsen Randall RN4016KNorth American NAVION · S/N NAV-4-1016Built 1947 · Hatch David GN414RWCessna 414A · S/N 414A0295Built 1979 · Jxc Holdings LLCN503AADJI AGRAS T40 · S/N 64TBL4A00200CWSkye Dreams LLCN528HBCirrus Design SR22T · S/N 2037Built 2019 · Cbs Aviation LLCN559CFCirrus Design SR22T · S/N 9765Built 2024 · Blair Church & Flynn Consulting EngineersN563SVPilatus PC-24 · S/N 563Built 2025 · Eddies Legacy LLCN60398Cessna 182T · S/N 18281834Built 2006 · Wagoner Aviation LLCN60DRBeech A36 · S/N E-1214Built 1978 · Sudeep Singh FlllpN6135RCessna 172RG · S/N 172RG0089Built 1979 · Stafford Michael JN615BTCirrus Design SR22T · S/N 8823Built 2022 · Eddies Legacy LLCN621CNHawker Beechcraft B200GT · S/N BY-44Built 2008 · Elite Team Offices IncN636RBBoyvey Roger V VANS RV-7 · S/N 72885Built 2010 · Turbo Property LLCN642JBCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 08SC243Built 2008 · Bonnar DavidN6956ECessna 175A · S/N 56456Built 1959 · Metzger GregN71135Luscombe 8A · S/N 2562Built 1946 · Jebb Steven JN753AWHawker Beechcraft B200GT · S/N BY-151Built 2012 · Etal CorpN758TACessna R172K · S/N R1723337Built 1980 · Stonehouse William LN79531Cessna 172K · S/N 17258155Built 1969 · Newberry Tyler DN814SRCirrus Design SR22 · S/N 2184Built 2006 · Gailforce Aviation LLCN81BKCirrus Design SR20 · S/N 1082Built 2000 · Singh AkashN821VVBeech C90 · S/N LJ-714Built 1977 · Elite Team Offices IncN8228EBeech D-45 · S/N BG-383Brown Robert LN8295YBeech A36 · S/N E-2825Bonanza Flyers LLCN8324DBeech J35 · S/N D-5426Built 1958 · Lacour ErikN833DBBlaise Kenny S HARMON ROCKET II · S/N 224Built 2007 · Turbo Property LLC
Back to Clovis, CA