Pleasanton, CA
Registered aircraft · 73
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 = 'PLEASANTON' 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 = 'PLEASANTON' 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.
N1096WCirrus Design SR22T · S/N 9053N1224YCessna 150B · S/N 15059624N1383ZCirrus Design SR22T · S/N 2224N1465APiper PA-22 · S/N 22-372N160SBBombardier BD-100-1A10 · S/N 20293N1766Pitts SC-1 · S/N NN-1N191MMDassault FALCON 7X · S/N 180N199CSSchleicher ASW-20 · S/N 20491N201LWMooney M20J · S/N 24-0507N202LLieberman Alan M LIEBERMAN GILES 202 · S/N 001N2298ERaytheon A36 · S/N E3138N24607Cessna T206H · S/N T20608277N246TJCirrus Design SR22 · S/N 0382N248MBSchleicher ASW-24B · S/N 24241N24TYSchleicher ASW-24B · S/N 24251N250DJBellanca 51 · S/N 0003-80N2561WMooney M20E · S/N 925N2577RCessna 182K · S/N 18258277N2667FCessna 182J · S/N 18256767N277WXDJI AGRAS T40 · S/N 64TBK7H00100F0N28CUNorth American T-28B · S/N 200302N28SPCirrus Design SR22T · S/N 10704N2974DCessna 170B · S/N 26917N29911Waco UPF-7 · S/N 5408N3135BBurke Lawrence P ULTRALIGHT · S/N 001N320HCessna 320B · S/N 320B0060N333AMCessna 414 · S/N 414-0651N34140Cessna 177RG · S/N 177RG0972N353GCirrus Design SR22T · S/N 11136N401DGGood David M CHRISTEN EAGLE II · S/N GOOD 0001N4141SBeech B-60 · S/N P-319N422SXCirrus Design SR22T · S/N 1867N431WCPilatus PC-12/45 · S/N 431N4704NCessna 182Q · S/N 18267294N4743SCessna TR182 · S/N R18201409N495SLAlair S C/Alair L P LEGACY 2000 · S/N L2K-167N504FMCessna 525B · S/N 525B0109N5091TCessna TR182 · S/N R18201814N509BAIcon A5 · S/N 00061N5321NBoeing E75 · S/N 75-5923N5417PPiper PA-24-250 · S/N 24-471N55KWCirrus Design SR22T · S/N 10705N56722Cirrus Design SR22T · S/N 11497N5714HPiper PA-16 · S/N 16-326N574SACirrus Design SR20 · S/N 9924N582BBBlackwood C G Bob JR CHRISTEN EAGLE II · S/N BLACKWOOD 0001N5988BCessna 182A · S/N 33988N6029JCessna A150L · S/N A1500329N61705Cessna 182Q · S/N 18265728N6202BCessna T210M · S/N 21062706
Back to Pleasanton, CA