Nevada City, CA
Registered aircraft · 40
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 = 'NEVADA CITY' 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 = 'NEVADA CITY' 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.
N122KPPeterson Keith D HARMON ROCKET · S/N PETERSON-2N13733Cessna 177B · S/N 17702462N152PCessna 182G · S/N 18255080First renewal noticeN174DVCessna 177RG · S/N 177RG1268N199MCCessna 172N · S/N 17268570N207TBEclipse EA500 · S/N 000179N222DRBeech V35A · S/N D-8604N22KPPeterson Keith D PETERSON RV-4 · S/N PETERSON-1N2418DCessna 170B · S/N 20570N260CDPiper PA-24-260 · S/N 24-4389N27291Northwestern PORTERFIELD LP-65 · S/N 772N28006Gulfstream American AA-5B · S/N AA5B0938N3047FPiper PA-28-181 · S/N 28-7990224N32471Culver LCA · S/N 203N3304VBeech 35 · S/N D-763N33169Piper PA-28-151 · S/N 28-7515326N336AFCessna 172L · S/N 17260404N38131Piper J5A · S/N 5874N4162GCessna 421C · S/N 421C0426N417DGGundy Darick C SONEX · S/N 1646N420PFWillman Loren LOREN'S AIRCAM · S/N 001N5111GCessna 182N · S/N 18260746N5600PPiper PA-24-250 · S/N 24681N5650TCessna 172E · S/N 17251550N5800MCessna T-310P · S/N 310P0100N6070RCessna 172G · S/N 17253739N6073FBeech 35-C33 · S/N CD-904N624CWPiper PA-32-301 · S/N 32-8006022N725SBCirrus Design SR20 · S/N 1363N745NBCirrus Design SR22 · S/N 1891N7635KPiper PA-20 · S/N 20-454N7674YPiper PA-30 · S/N 30-752N7895RBeech E33 · S/N CD-1210N8132Travel Air L-4000 · S/N 902First renewal noticeN81578Aeronca 7BCM · S/N 7AC-197N920HWWikstad H L/Wikstad R A RV-4 · S/N 920N94805Ercoupe 415-E · S/N 4918N9571MMooney M20F · S/N 670148N9721MMooney M20C · S/N 670138N9834MMaule M-4-210S · S/N 1-S
Back to Nevada City, CA