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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1387YCessna 172C · S/N 17249087N13WHClassic WACO YMF · S/N F5-013N153PTAmerican Legend AL11C-100 · S/N AL-1023N1624EAeronca 7AC · S/N 7AC-5189N1964ZCessna 150C · S/N 15059764N210FCCessna 421B · S/N 421B0908N2192LBeech E-90 · S/N LW-192N2256AAyres S2R-G10 · S/N G10-135N2269UNorth American-Medore SNJ-4 · S/N 88-12850N23849American Legend AL11C-100 · S/N AL-1009N239MMeyers Industries 200D · S/N 294N240LAAir Tractor AT-802A · S/N 802A-0375N252SHDiamond Aircraft Ind DA 62 · S/N 62.C123N25EAEagle EAGLE 150B · S/N 029N2602WMooney M20E · S/N 951N26EBBrowning STARDUSTER SA-100 · S/N EB1N277KABell 206B · S/N 2177N27817North American AT-6G · S/N 51-14916N2864GNorth American SNJ-6 · S/N 112169N2868VBeech 35 · S/N D-273First renewal noticeN31086Piper J3F-65 · S/N 5314N342PBHawker Beechcraft C90GTI · S/N LJ-1960N3576UCessna 182F · S/N 18254976N366NENorth American P-51D-5 · S/N 44-11203N38676Piper J3C-65 · S/N 7185N3891YCessna 210D · S/N 21058391N389AMDiamond Aircraft Ind DA20-C1 · S/N C0389N39722Stadel Norman M ACEY DEUCY P-70 · S/N AD255N40615Piper J3C-65 · S/N 7370N4220ZPiper PA-18-150 · S/N 18-8443N4223UStadel Norman M P - SHOOTER · S/N .01N4470APiper PA-18A 150 · S/N 18-4822N4480Bell UH-1B · S/N 64-13906N4572EAeronca 7AC · S/N 7CCM-138N4727MPiper PA-11 · S/N 11-239N4761ACessna P210N · S/N P21000821N4773KCessna P210N · S/N P21000304N5108NCessna 182Q · S/N 18267520N5448CCessna 170A · S/N 19482N556LAEavision EA-J150 · S/N JMZKJ150UAV602596259N58350Hughes Helicopters HUGHES 369D · S/N 790546DN5869BCessna 182A · S/N 33869N6139VAir Tractor AT-402B · S/N 402B-0982N6179XInfinity Power Parachutes INFINITY 2001 · S/N A13KDCN634CTAero Commander 500 S · S/N 3121N6355ECessna 172 · S/N 46455N68514Bellanca 7KCAB · S/N 325-72N6884XCessna 210A · S/N 21057664First renewal noticeN6939QBeech A23A · S/N M-1086N6999RCessna 172E · S/N 17251549
Back to Yuba City, CA