OpenAirDocs.org
Visalia, CA

Registered aircraft · 132

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

N106BDRoetman Ryland K JR EAGLE · S/N BR001Built 2003 · Lemons Brooks DN10LTLithuanian Factory Of LAK-12 · S/N 6199Built 1992 · Golomb Lawrence JrN115YSBeech E-90 · S/N LW126Built 1974 · Tunnell DarrellN1278HPiper PA-34-200T · S/N 34-7770118Metzner BradN133WHHiller UH-12E · S/N 1788Built 1973 · Four Creeks Aviation IncN1456FCessna 172H · S/N 17254951Built 1966 · Beames Delbert AN146ETHiller UH-12E · S/N HA3046Built 1976 · Four Creeks Aviation IncN155AEMooney M20M · S/N 27-0014Built 1989 · Bissat Rashid HN158CCPiper PA-28R-201 · S/N 28R-7737081Registration pendingBuilt 1977N160RWRaytheon B300 · S/N FL-226Built 1998 · Ritch Air LLCN1708WBeech S35 · S/N D-7340Built 1964 · Cassaday Jonathan AN177WTBeech M35 · S/N D-6300Bucey Barry EN17VABeech 200 · S/N BB-670Built 1980 · Optimal Aviation Services LLCN18233Cessna 150L · S/N 15073886Built 1972 · Geiger KurtisN18469Beech A36 · S/N E-1141Built 1977 · Bonanza 469 LLCN189JCTextron T206H · S/N T20609510Built 2017 · Tulare County SheriffN18PRMaule M-5-220C · S/N 6198CBuilt 1977 · Denicola FrankN191BWCirrus Design SR20 · S/N 1577Built 2005 · Sung Properties LLCN2017Texas Aircraft Mfg COLT 100 · S/N TXA003Sale reportedBuilt 2020N20591Cessna 172M · S/N 17261423Built 1973 · Vogt Roger DN2065WBeech 35-C33 · S/N CD-986Built 1966 · Smith LawrenceN2094YCessna 172D · S/N 17249594Built 1963 · Hill Karl AN2114MPiper PA-28R-201T · S/N 28R-7803108Built 1977 · Kilo Delta Force LLCN2150XMooney M20S · S/N 30-0036Built 1999 · Cascade Airplanes IncN21RVNicholson Knox W RV-4 · S/N 1103Built 1988 · Haworth Matthew TN220HPiper PA-18-150 · S/N 18-7709118Todd Greg AN229LBBuchanan Lee RV8A · S/N 80659Built 2003 · King David WN2305BTemco GC-1B · S/N 3605Doyal William TN235WSPiper PA-28-235 · S/N 28-10156Built 1963 · Garza Johnny RN2401KLuscombe 8E · S/N 5128Built 1947 · Lemons Brooks DN2457CCessna 182T · S/N 18280947Morris Velma LN2463FDJI AGRAS T40 · S/N 1581F574B227400101MDGrouse Creek Farms LLCN2560VCessna 170 · S/N 18065Built 1948 · Crowley John ArthurN2661VCessna 170 · S/N 18171Built 1948 · Parker Alan AN279TXCirrus Design SR22T · S/N 0877Hester Air LLCN284GPilatus PC-12/45 · S/N 217Built 1998 · Gtn Aviation LLCN302AMMooney M20E · S/N 618Built 1965 · Hughes JasonN307KMCessna 172D · S/N 17250381Built 1963 · Mcphaill KevinN30JXPiper PA-30 · S/N 30-539Built 1964 · Optimal Aviation Services LLCN314KVVance Kyle L THATCHER CX4 · S/N 474Vance Kyle LN317DCDavid B Casey VANS RV8 · S/N 83103Built 2012 · Ramsey Beau AN32784Piper PA-28R-200 · S/N 28R-7535090Built 1974 · Denicola Frank JN333EFPiper PA-32R-301T · S/N 3257053Built 1998 · Tmak IncN333TBeech 58 · S/N TH-1779Built 1996 · Kayair LLCN3378ECessna 172N · S/N 17271524Built 1978 · Visalia Flyers LLCN3558ECessna 172N · S/N 17271586Built 1978 · Visalia Flyers LLCN3561SCessna 172E · S/N 17250761Munoz ChristianN357HRCessna T206H · S/N T20609050Built 2012 · Martin Hein Ranch CoN3598UCessna 182F · S/N 18254998Built 1963 · Dunn MarkN359DGTextron B300 · S/N FL-1328Built 2023 · Gaf Holdings Inc
Back to Visalia, CA