OpenAirDocs.org
Ukiah, CA

Registered aircraft · 39

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

N1076XPiper PA-28-151 · S/N 28-7515383Built 1975 · Marston Lester JN1187UCessna 172M · S/N 17266888Built 1976 · Niderost GregN1892VCessna 172M · S/N 17263784Built 1974 · Smith Air IncN2186XCessna 337 · S/N 337-0086Built 1965 · Ashiku PhillipN2231KLuscombe 8E · S/N 4958Built 1947 · Bishop Elijah ArN2254VCessna 140 · S/N 14485Phillip AshikuN276ACCessna 210L · S/N 21061442Built 1976 · Smith Air IncN288RTChampion 7KCAB · S/N 7KCAB-43Built 1967 · Savonen Stephen DN30516Cessna T210L · S/N 21059927Built 1973 · J A Sutherland IncN34989Cessna 177B · S/N 17702140Built 1974 · Johnson Edward AN365WCCessna 182T · S/N 18281170Built 2002 · Crane Douglas FN3841GCessna TU206B · S/N U206-0841Built 1967 · Whetzel Michael LN3846DCessna 182A · S/N 34546Built 1957 · Ashiku PhillipN4135NCessna 140 · S/N 13598Built 1947 · Paige Richard C JrN451RBLindsey Monoplane 4 · S/N 4Bishop Elijah A RN4524ZGulfstream American AA-5B · S/N AA5B1111Built 1979 · Mercer Eric SN4715FCessna P206B · S/N P206-0315Registration pendingBuilt 1966N4881LPiper PA-28-180 · S/N 28-4247Built 1967 · Honeycutt Stephen DN490AFCessna 177B · S/N 17701493Built 1970 · Eiffert Matthew TN5774BCessna 182 · S/N 33774Built 1956 · Ashiku PhillipN59961Consolidated Vultee BT-13A · S/N 7722Built 1942 · Bishop Nicholas EN6856VMooney M20F · S/N 22-1249Built 1975 · Hudson Daryl JN6984DDerickson James L ZENITH CH-750 · S/N 75-7889Built 2010 · Derickson James LN7073VMooney M20C · S/N 20-1210Built 1976 · Owen GregN734XSCessna 172N · S/N 17269202Built 1977 · Crabtree Clifford IN737HMCessna 172N · S/N 17269430Built 1977 · Meyer RaymondN756QXCessna R182 · S/N R18201132Built 1979 · Mayfield Kyle BarnesN7615Baby Ace G · S/N GK-2Built 1967 · Bishop Elijah A RN7680GCessna 172L · S/N 17259380Gulyash Michael JN77946Luscombe 8A · S/N 3673Built 1946 · Gramke John MN80773Cessna 172M · S/N 17266740Built 1976 · Boyl Traci LN857CSCharles E Smith JR MOSQUITO XE285 · S/N MXE133F18BBuilt 2018 · Beaver GregN8751SCessna 150F · S/N 15062051Built 1966 · Morris Jeffery SN8883TCessna 182C · S/N 52783Built 1960 · Bishop Nicholas EdwardN89390Cessna 152 · S/N 15282734Built 1978 · Nevill Jordan JN9115LChampion 7ECA · S/N 797-71Built 1970 · Savonen Stephen DN927DRRosenkranz Walter VANS RV8A · S/N 82849Built 2010 · Butts John CN93593Engineering & Research ERCOUPE 415-C · S/N 916Built 1946 · Jones Bruce BN9874TCessna 172A · S/N 47674Built 1960 · Vichy Springs Resort Inc
Back to Ukiah, CA