Grass Valley, CA
Registered aircraft · 107
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 = 'GRASS VALLEY' 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 = 'GRASS VALLEY' 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.
N100YAAmerican AA-5 · S/N AA5-0086N116PTWarner Dennis D RIDGE RUNNER IIIS · S/N 011406124First renewal noticeN1267SCessna 182P · S/N 18264835N13298Bell 47G-2 · S/N 1346N1493GGood Drone GDC CARGO DRONE · S/N 00002N158MPXag P100 PRO · S/N 1863FPEG8219425G3G48N166CMRans S-12XL AIRAILE · S/N 6950612N172FKCessna 172S · S/N 172S11249N180Cessna 180K · S/N 18052946N181YPiper PA-28-181 · S/N 28-8590089N1835BBeech 95-B55 (T42A) · S/N TC-2076N1886HCessna 310C · S/N 35986N19232Piper J-2 · S/N 1632N2035KLuscombe 8E · S/N 4762N206EKCessna TU206G · S/N U20606291N2197QCessna 177RG · S/N 177RG0597N2213KLuscombe 8A · S/N 4940N231AQMooney M20K · S/N 25-0103N232WTGardner Marvin F1 EVO · S/N 175N233GKBeech V35A · S/N D-8777N251HPCessna 172RG · S/N 172RG1124N279LHVans RV-12 · S/N 120201N2872HEngineering & Research 415-C · S/N 3497N293DCDiamond Aircraft Ind DA20-C1 · S/N C0193N301AKButner V L/Butner M D ZENITH 801 · S/N 8-3948Sale reportedN3152ZPiper PA-22-150 · S/N 22-7096N32137Waco UPF-7 · S/N 5769N32810Piper PA-32-300 · S/N 32-7540067N33092Piper PA-28-140 · S/N 28-7525153N34471Cessna 177B · S/N 17701827N3496YCessna 180H · S/N 18051996N36587Aeronca 65-CA · S/N C16511N386JKFlight Design CTSW · S/N 06-12-23N3XMMcclung Pat RV-6 · S/N B93F96N405RARemos REMOS G-3/600 · S/N 236N4130XWittman W-8 TAILWIND · S/N 132N416RBStarduster Too SA300 · S/N 95N42363Piper PA-28-151 · S/N 28-7415389N44923Naval Aircraft Factory N3N-3 · S/N 4397N44978Naval Aircraft Factory N3N-3 · S/N 2843N4557VGulfstream American AA-5B · S/N AA5B1236N4QRAviat A-1 · S/N 1363N505WTDiamond Aircraft Ind DA 40 · S/N 40.202N50RDDundas Ronald S KITFOX III · S/N 901N5132WPiper PA-28-160 · S/N 28-161N515JDJohn A Dalessandris PITTS S1S · S/N RB2016N5226ZPiper PA-22-108 · S/N 22-8902N5271RCessna 172M · S/N 17263485N529FGGalloway Fred J RV9A · S/N 91123N54PLLodrige Paul EXEC · S/N 0101
Back to Grass Valley, CA