Woodland, CA
Registered aircraft · 75
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 = 'WOODLAND' 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 = 'WOODLAND' 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.
N1009PCessna 182A · S/N 34994N1061EBellanca 7GCBC · S/N 975-77N11799Cessna 177B · S/N 17702369N1286BLuscombe 8A · S/N 5913N158CBBugbee Calvin A TITAN TORNADO II · S/N D99912SOHK0332N1706MCessna 337E · S/N 33701306N195DBAnderson BREEZY CVA · S/N 2N19ACCruz Armando RV-4 · S/N 578N2064CBeech 95-B55 (T42A) · S/N TC-2212N2083SCessna T210L · S/N 21061049N2188BLuscombe 8A · S/N 6615N222CUGlen Oliver SLING 4 TSI · S/N 263SKN22745Piper J3C-65 · S/N 2712N234SCST Clair R C LONGEZE · S/N 286N23717Beech A36 · S/N E-1208N23KWGoldner Leslie M CUMULUS · S/N 05103N240FDFletcher FD-25B · S/N 3N2420TNavion NAVION G · S/N NAV-4-2420N24HPCessna 182P · S/N 18263568N279SPAerosport BREEZER · S/N 001LSAN3143DMelby David G CAVALIER · S/N SA1025-75013LFN334PDBeech 35-C33 · S/N CD-814N3473FCessna 182J · S/N 18257473N36363Beech V35B · S/N D-9748N36796Stinson 10A · S/N 8096N3919ZPiper PA-18-150 · S/N 18-7743N4011ERobinson Helicopter R22 BETA · S/N 1385N409BBeech 35 · S/N D-1414N411JHMcdonnell Douglas Helicopter 369E · S/N 0193EN414LACessna 414A · S/N 414A0077N41XYDewsnup Dave ZENAIR CH 701 SP · S/N 7-9394First renewal noticeN4781QCessna A188B · S/N 18802523N5044NAir Tractor AT-502B · S/N 502B-0452N50TGTextron T206H · S/N T20609230N511KVBeech C90A · S/N LJ1422N514LHAir Tractor AT-502B · S/N 502B-2874N5450Grumman Acft ENG Cor-Schweizer G-164A · S/N 1160N551ZGlasflugel STD LIBELLE 201B · S/N 551N55827Piper PA-28-180 · S/N 287305477N5796Fairchild KR-31 · S/N 175N57WYAviat A-1C-200 · S/N 3127N5891QDJI PHANTOM 3 PROFESSION · S/N P76DCF12016502N6023ZBeech A36 · S/N E-1468N608RHAir Tractor AT-502B · S/N 502B-2737N636FSDJI PHANTOM 3 PROFESSION · S/N P76DCH24A21195N637VS3D Robotics SOLO · S/N S111A5706542N6394PPiper PA-24-250 · S/N 24-1504N6428SBeech V35B · S/N D-9842N6597UMooney M20C · S/N 2379N6714CAeronca 7CCM · S/N 7CCM-64
Back to Woodland, CA