Yuba City, CA

Registered aircraft · 76

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 = 'YUBA CITY'
  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.

N1387YCessna 172C · S/N 17249087Built 1961 · Bi-County Ambulance Service IncN13WHClassic WACO YMF · S/N F5-013Built 1988 · Lonon Michael EN153PTAmerican Legend AL11C-100 · S/N AL-1023Built 2006 · Green JohnN1624EAeronca 7AC · S/N 7AC-5189Built 1946 · Stadel Jim DN1964ZCessna 150C · S/N 15059764Built 1962 · Greene John PN210FCCessna 421B · S/N 421B0908Built 1975 · Baked Industries IncN2192LBeech E-90 · S/N LW-192Built 1976 · Siller Brothers IncorporatedN2256AAyres S2R-G10 · S/N G10-135Built 1997 · Twin Cities Aviation IncN2269UNorth American-Medore SNJ-4 · S/N 88-12850Clemens Amy TN23849American Legend AL11C-100 · S/N AL-1009Built 2005 · Borzelleri Joseph EricN239MMeyers Industries 200D · S/N 294Built 1965 · Watkins DouglasN240LAAir Tractor AT-802A · S/N 802A-0375Built 2010 · Twin Cities Aviation IncN252SHDiamond Aircraft Ind DA 62 · S/N 62.C123Highflyair LLCN25EAEagle EAGLE 150B · S/N 029Built 1999 · Reese DallanN2602WMooney M20E · S/N 951Built 1965 · Hartman William JN26EBBrowning STARDUSTER SA-100 · S/N EB1Built 1978 · Hartman William JN277KABell 206B · S/N 2177Twin Cities Aviation IncN27817North American AT-6G · S/N 51-14916Built 1951 · Allen SeanN2864GNorth American SNJ-6 · S/N 112169Built 1959 · Hartman William JN2868VBeech 35 · S/N D-273First renewal noticeBuilt 1947 · Biehle Michael AN31086Piper J3F-65 · S/N 5314Built 1940 · Cabigas John VN342PBHawker Beechcraft C90GTI · S/N LJ-1960Built 2009 · Orchard Machinery CorpN3576UCessna 182F · S/N 18254976Built 1963 · Binse Gerald RN366NENorth American P-51D-5 · S/N 44-11203Edwards Roger Don JrN38676Piper J3C-65 · S/N 7185Built 1941 · Bowles Thomas MN3891YCessna 210D · S/N 21058391Built 1964 · Cartwright ChrisN389AMDiamond Aircraft Ind DA20-C1 · S/N C0389Built 2006 · Feather River Sport Aviation LLCN39722Stadel Norman M ACEY DEUCY P-70 · S/N AD255Built 1983 · Stadel Aircraft IncN40615Piper J3C-65 · S/N 7370Built 1941 · Stadel Aircraft IncN4220ZPiper PA-18-150 · S/N 18-8443Built 1966 · Lonon Michael EN4223UStadel Norman M P - SHOOTER · S/N .01Built 2004 · Stadel Aircraft IncN4470APiper PA-18A 150 · S/N 18-4822Built 1956 · Anderson Stephen AN4480Bell UH-1B · S/N 64-13906Twin Cities Aviation IncN4572EAeronca 7AC · S/N 7CCM-138Built 1949 · Mescher Daniel RN4727MPiper PA-11 · S/N 11-239Built 1947 · Leland Edwin SN4761ACessna P210N · S/N P21000821Built 1983 · Amarel Robert E JrN4773KCessna P210N · S/N P21000304Built 1979 · Reason FarmsN5108NCessna 182Q · S/N 18267520Berry Lisa AN5448CCessna 170A · S/N 19482Built 1950 · Beamer Nicholas JN556LAEavision EA-J150 · S/N JMZKJ150UAV602596259Aerospray LLCN58350Hughes Helicopters HUGHES 369D · S/N 790546DBuilt 1979 · Siller Helicopters IncN5869BCessna 182A · S/N 33869Goodman DavidN6139VAir Tractor AT-402B · S/N 402B-0982Built 1995 · Russel Armstrong & Danny Hawk DBA Onstott DustersN6179XInfinity Power Parachutes INFINITY 2001 · S/N A13KDCCrawford Kurt DN634CTAero Commander 500 S · S/N 3121Built 1972 · Corsair Aviation LLCN6355ECessna 172 · S/N 46455Built 1959 · Massey David AN68514Bellanca 7KCAB · S/N 325-72Twin Cities Aviation IncN6884XCessna 210A · S/N 21057664First renewal noticeBuilt 1960 · Baked Industries IncN6939QBeech A23A · S/N M-1086Built 1967 · Baker Jeffrey MN6999RCessna 172E · S/N 17251549Worswick Dwight D
Back to Yuba City, CA