Novato, CA
Registered aircraft · 53
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 = 'NOVATO' 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 = 'NOVATO' 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.
N1013Bombardier BD-100-1A10 · S/N 20229N111FRPiper PA-28-140 · S/N 28-7325055N129THSukhoi SU-29 · S/N 76-01N1347RGrumman American Avn. AA-5 · S/N AA5-0747N16527Piper PA-28-180 · S/N 28-7305274N2116JPiper PA-28-161 · S/N 28-7916197N2178SCessna R182 · S/N R18201310N219WESocata TB-20 TRINIDAD · S/N 1695N226SUSukhoi SU-26 · S/N 05-08N234HYAviat A-1B · S/N 2415N234TMCessna 182P · S/N 18264768N25096Socata TB-20 TRINIDAD · S/N 961N274JHHoffmann HK 36R SUPER DIMONA · S/N 36401N30374Cessna T210L · S/N 21059918N3060TPiper PA-28RT-201T · S/N 28R-7931087N32366Porterfield LP-65 · S/N 820N32BLBeech B36TC · S/N EA-296N338XPDJI AGRAS T50 · S/N 1581F6BUB245P001803XN3408BBeech D35 · S/N D-3646N36056Piper PA-28-161 · S/N 28-7816609N368LMDJI AGRAS T50 · S/N 1581F6BUB23AQ0014W64N401SACirrus Design SR20 · S/N 10598N403PBBolenbaugh Phillip W RANS S-6ES COYOTE II · S/N 12081912-ESN424CBCessna 182L · S/N 18258975N427LJCirrus Design SR20 · S/N 2513N42MKHeidenreich Mark M RANS S-6S · S/N 01N525SJCessna 525C · S/N 525C0170N5343EBlue Side UP Aviation GRP ONEX · S/N 0074N550TKKenney III Frank M RV-7 · S/N 74591N5777HMooney M20J · S/N 24-1507N6461RPiper PA-28-140 · S/N 28-21648N6625VBellanca 17-30A · S/N 30285N676RVVans RV-12 · S/N 120103N6777TCessna 177 · S/N 17701049N713EAeropro CZ EUROFOX LSA 3K · S/N 255 08N717MMBeech F33A · S/N CE-831N731WCRaytheon A36 · S/N E-3404N7338BBeech E35 · S/N D-3801N759BZCessna 182Q · S/N 18265875N762SSpink Robert M PIETENPOL AIRCAMPER · S/N 1691N7865NPiper PA-28-180 · S/N 28-5322N80590Cessna 172M · S/N 17266663N812DLVans RV-12 · S/N 120063N8350RPiper PA-28-140 · S/N 28-22225N858ALBeech A36 · S/N E2544N8986MBeech S35 · S/N D-7313N9089PPiper PA-24-260 · S/N 24-4563N910CVVashon RANGER R7 · S/N 10174N95137Taylorcraft BC12-D · S/N 9537N960MPCompagnie Daher TBM 700 · S/N 1450
Back to Novato, CA