Hayward, CA
Registered aircraft · 88
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 = 'HAYWARD' 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 = 'HAYWARD' 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.
N105GXRemos Acft Gmbh Flugzeugbau REMOS GX · S/N 289N1080WBeech F33A · S/N CE-435N1146TMooney M20J · S/N 24-1200N11FZNavion NAVION A · S/N NAV-4-263N1216MCessna 182P · S/N 18264245N122RAAvery Rex A AVERY/MINI MAX · S/N 427PN1247SCessna 182P · S/N 18264816N14CGChristopher Jewett QUICKSILVER SPORT 2S · S/N 0326N155STBeech 95-B55 (T42A) · S/N TC-651N163BCAmerican Champion 7GCBC · S/N 1370-2004N172CACessna 172N · S/N 17270629N1813VCessna 120 · S/N 13998N19410Cessna 150L · S/N 15074405N198WMWright Macleod Doelcam Special STEEN SKYBOLT · S/N 001N200DSBellanca 17-30A · S/N 74-30699N2015VBeech K35 · S/N D-5760N2117KLuscombe 8E · S/N 4844N227CDEiriavion PIK 20D · S/N 20592N23KPLancair LC41-550FG · S/N 41004N250ACLeading Edge Aerial Tech PV40X · S/N 11440N274ERPiper PA-44-180 · S/N 44-7995083N2770RPiper PA-28R-200 · S/N 28R-35287N2931UCessna 172D · S/N 17250531N2TLBeech 95 · S/N TD-233N30WGBeech E-55 · S/N TE-997N333PLCessna 182P · S/N 18261303N34EEPiper PA-30 · S/N 30-1138N3574TTaylorcraft F19 · S/N F-040N358WCCessna 525A · S/N 525A0306N3599HMooney M20C · S/N 20-1238N3690VCessna 120 · S/N 14966N3711NBeech 76 · S/N ME-375N390NLLininger Jack A LONG WING CHEROKEE · S/N LM2N40746Piper PA-28R-200 · S/N 28R-7435119N414EECessna 414A · S/N 414A1204N445DBBombardier BD-700-1A11 · S/N 9400N4850WRockwell International 114 · S/N 14180N48932Cessna 152 · S/N 15281056N4902FCessna 172N · S/N 17273099N49039Cessna 152 · S/N 15281115N49821Cessna 152 · S/N 15283520N5051QBellanca 8KCAB · S/N 526-79N50948Cessna 150J · S/N 15069668N52245Bellanca 8KCAB · S/N 164-75N52275Cessna 172P · S/N 17274475N5335PCessna 152 · S/N 15284919N56VBSanitas CCX-1865 · S/N CCX-1865-2012N58GXPilatus PC-12/47E · S/N 2134N604DBSchleicher ASW-27 · S/N 27124N621SCAgusta A109S · S/N 22078
Back to Hayward, CA