Healdsburg, CA
Registered aircraft · 43
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 = 'HEALDSBURG' 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 = 'HEALDSBURG' 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.
N1131WCessna 182P · S/N 18264584N118EKKempkey THORP T-18 · S/N 658N129TTTextron 525B · S/N 525B0684N12ASCessna A185F · S/N 18502271N151FBeech 95-B55 (T42A) · S/N TC-613N17BGlasflugel H 301 LIBELLE · S/N 21N2406KPiper PA-38-112 · S/N 38-79A0619N2515ZBellanca 7GCAA · S/N 347-77N256DXCompagnie Daher TBM 700 · S/N 1623N3717RPiper PA-28-180 · S/N 28-5807N3862RBeech A36TC · S/N EA-217N407DKBell Helicopter Textron Canada 407 · S/N 54583N4146ARaytheon B36TC · S/N EA-646N4425PStinson 108-1 · S/N 108-755N45406Grumman American Avn. AA-5B · S/N AA5B1315N48657Aeronca 0-58B · S/N 058B10243N5440PPiper PA-24-250 · S/N 24-494N5469XCessna P210N · S/N P21000507N552PGCirrus Design SR20 · S/N 2007N56205Boeing A75N1(PT17) · S/N 75-186N56376Stinson L-5 · S/N 76-378N61576Cessna 180K · S/N 18052782N62KHHawker Beechcraft G36 · S/N E-3923N657WCCub Crafters CC19-215 · S/N CC19-0075N678GWCirrus Design SR22 · S/N 2602N7070LRobert S Leach RV-14A · S/N 140996N726EGCirrus Design SR20 · S/N 1442N7382NCessna 182P · S/N 18263165N74458Grumman American Avn. AA-5B · S/N AA5B-0233N7969GCessna 172L · S/N 17259669N8065MCessna 182P · S/N 18264536N8103DPipistrel VIRUS 912 · S/N 141V9120604KIT49N82520Piper PA-18-150 · S/N 18-7709170N854VWaco RNF · S/N 3269N85WJMaule MT-7-235 · S/N 18110CN8602QBeech S35 · S/N D-7633N88226Piper J3C-65 · S/N 15843N90333Globe GC-1B · S/N 347N91264Canadian Car & Foundry HARVARD MK IV · S/N CCF4-123N9265UCessna 150M · S/N 15078215N97979Stinson 108-1 · S/N 108-979N9894ACessna 195A · S/N 7597N9YOldfield SPECIAL · S/N 1
Back to Healdsburg, CA