Groveland, 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 = 'GROVELAND' 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 = 'GROVELAND' 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.
N1170FCessna 172G · S/N 17254765N1181Johanson Jason M FALCON · S/N 001N11GFBellanca 7GCBC · S/N 668-74N123BRStol UC-1 · S/N 012N12438Waco QDC · S/N 3579Sale reportedN124ELVans RV-12 · S/N 120793N124SMoorman Steve LANCAIR 360 · S/N S696N1312SCessna 182P · S/N 18264877N1380JRockwell International 112A · S/N 380N15857Rearwin 7000 · S/N 458Sale reportedN1640DCessna 170B · S/N 20282N164CLNorth American SNJ-5 · S/N 85056N171MCKenneth L Orloff MARQUART MA-5 · S/N 1001N199KMBeech V35B · S/N D-10243N21427Air Creation Trike TWIN · S/N 100452N219CBRans Designs S-21LS OUTBOUND · S/N 12190079N22037Cessna 150H · S/N 15068023N23XWRex Pemberton X11 · S/N X11N2412YFales Bruce F AIR CAM · S/N AC-089N250MPStol UC-1 · S/N 010N2684FCessna 182J · S/N 18256784N28094Piper J3C-65 · S/N 14387N292SMCato Robert E GLASAIR SH-2FT · S/N 663N2CSBeech V35B · S/N D-9463N31636Piper PA-28-181 · S/N 28-7890472N321CCPiper PA-23-250 · S/N 277304950N333GTTriplett Gregory VANS RV-4 · S/N 1333N344CLFairchild Heli-Porter PILATUS PC6/C-H2 · S/N 2019N35821Cessna 177RG · S/N 177RG1056N36CSBeech A36 · S/N E-973N391STRobert A Ashey RV10 · S/N 40802N3956RPiper PA-28-180 · S/N 28-7105061N4196GCessna 182S · S/N 18280367N44684Culver V · S/N V75Sale reportedN44NSMooney M20J · S/N 24-0913N4511HMooney M20J · S/N 24-0755N4542CCessna 170B · S/N 25486N45DTBeech A45 · S/N G-785N45KLOrloff Kenneth L LANCAIR IV P · S/N LIV-158N489KTTalovich Kenneth F RV8 · S/N 82314N5231RCessna 172M · S/N 17263445N525MVGustafson Mike L RV-7 · S/N 71520N540VBExtra Flugzeugbau EA-300 · S/N 033Registration pendingN54480Ryan Aeronautical ST3KR · S/N 1941Sale reportedN554CLBeech 95-C55 · S/N TE-99N55525Piper PA-28-140 · S/N 28-7325426N611MJHunter John A-26 TWIN VISTA SS · S/N 015N61646Ryan Aeronautical ST3KR · S/N 1612N65LESchempp-Hirth VENTUS-B · S/N 108N66978Cessna 172P · S/N 17275995
Back to Groveland, CA