Livermore, CA
Registered aircraft · 181
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 = 'LIVERMORE' 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 = 'LIVERMORE' 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.
N10006Beech D-45 (T-34B) · S/N BG-72N100FPCessna 182P · S/N 18262957N106VASteven Deford VANS RV-10 · S/N 41487N1080MCessna 182Q · S/N 18266034N108EMFlight Design CTSW · S/N 06-08-07N10CXCessna 206H · S/N 20608082N110GMMckenzie Greg CHRISTEN EAGLE II · S/N MCKENZIE 0001N112VVDarland Charles B RV-9A · S/N 90190N115JSocata TB 10 · S/N 607N11776Monocoupe 90A · S/N A-705N124PSPilatus PC-12/47E · S/N 1811N12592Beech B17L · S/N 12N12599Cessna C-34 · S/N 254N1449VCessna 172M · S/N 17263586N14727Fairchild 24 C8C · S/N 2649N14DZShay S Ohayon SLING TSI · S/N 419SKN155JSScheibe L SPATZ-55 · S/N 641N16769Piper J-2 · S/N 771N17LVBeechcraft G36 · S/N E-4062N185PXCessna A185F · S/N 18502795N1862XCessna 182H · S/N 18255962N187MACessna 182L · S/N 18259207N1940FCessna 172N · S/N 17273030N196JBExtra Flugzeugbau EA300/200 · S/N 01N19989Phillips CT-2 · S/N 101N19ZCruikshank Bruce M RV-4 · S/N 551N1TECastlebary Tom MUSTANG II · S/N 424N2037PPiper PA-23 · S/N 23-614N206TGBell 206B · S/N 2610N20758Cessna C-165 · S/N 482N20967Waco SRE · S/N 5089N2146DBeech D35 · S/N D-3491N2170MCessna 182P · S/N 18265133N21HHSchempp-Hirth MINI-NIMBUS HS7 · S/N 53N225XBeech H35 · S/N D-5032N2260SCessna T210L · S/N 21061204N2269TNorth American-Medore SNJ-4 · S/N 88-12841N231NLMooney M20K · S/N 25-0325N2329Waco EGC-8 · S/N 5062N234WSMooney M20R · S/N 29-0343N235DBPiper PA-28-235 · S/N 28-10722N2394VCessna 140 · S/N 14635N24470Cessna 182S · S/N 18280823N24831Cessna 152 · S/N 15280403N253DGPilatus PC-24 · S/N 171N26560Cessna 421C · S/N 421C0802N2697BTemco TT-1 · S/N 144227BN2706UCessna 172D · S/N 17250306N2744XCessna 414A · S/N 414A0812N276TMPiper PA-32-300 · S/N 327940006
Back to Livermore, CA