Hollister, CA
Registered aircraft · 62
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 = 'HOLLISTER' 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 = 'HOLLISTER' 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.
N107MHKubicek Factory S R O BB26AZ · S/N 2641N1233APiper PA-18-125 · S/N 18-848N13619Cessna 172M · S/N 17262887N147DLCurtis David RV-4 · S/N 2632N1685GChampion 7GCAA · S/N 194N16904Fairchild 24 H · S/N 3213N179KSSchleicher ASK-21 · S/N 21236N180DACessna 180 · S/N 32476N180LGCessna 180 · S/N 31380N202GGAlexander Schleicher ASK 21 · S/N 21832N2289BBeech 35-C33A · S/N CE-178N2457Boeing A75N1(PT17) · S/N 75-2717N2467NCessna 140 · S/N 12720N25108Luscombe 8A · S/N 1032N2578NCessna 140 · S/N 12838N2777BBeech E33A · S/N CE-281N280LGLonnie E Autry JR RV-8 · S/N 83377N3013NPiper PA-28-236 · S/N 28-7911100N3030XCessna 162 · S/N 16200101N30653Piper J3C-65 · S/N 5014N307GCessna 172M · S/N 17263007N32027Waco UPF-7 · S/N 5658N3207LBeech A36 · S/N E-935N337SPStorm RALLY LSA · S/N R3-00R-0001N340JMCessna 340A · S/N 340A0640N3498SCessna 182H · S/N 18255898N350ELRosiak Edward A LANCAIR ES · S/N ES-016-FBN38733Piper PA-28-181 · S/N 28-7790580N3966RPiper PA-28-180 · S/N 28-7105072N4082VNorth American SNJ-5 · S/N 51733-1N409VADornier DORNIER 228-202 · S/N 8097N4335DPiper PA-28-181 · S/N 28-8490043N45647Luscombe 8A · S/N 2174N4669YPiper PA-25-235 · S/N 25-4392N4753HPiper PA-11 · S/N 11-665N4895GCessna 172N · S/N 17273442N5180VBeech C-45H · S/N 51-11689AN520EDDarin E Delcurto MXL SPORT 2 · S/N 600963N5460VNorth American/Aero Classics P-51D · S/N 44-72192N5908PPiper PA-24-250 · S/N 24-994N61662Cessna 180K · S/N 18052787N628PLPost Philip H KITFOX IV · S/N 1522N6764NMooney M20E · S/N 690001N6979CNorth American AT-6D · S/N 42-85408N70373Piper J3C-65 · S/N 17356N7092ZPiper PA-25-235 · S/N 25-2879N73BBPiper J3C-65 · S/N 15553N7560SCessna TR182 · S/N R18201712N759NACessna 182Q · S/N 18266116N76JVVilleneuve John J RV-6 · S/N 21071
Back to Hollister, CA