Mountain View, CA
Registered aircraft · 52
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 = 'MOUNTAIN VIEW' 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 = 'MOUNTAIN VIEW' 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.
N106VKCessna 172S · S/N 172S9051N121SSCessna 150M · S/N 15076450N1245ZDukhovny/Petrov/Kisly/Markin ARMADA MODEL ZERO · S/N 1N13475Cessna 172M · S/N 17262778N151BHAmerican Champion 8KCAB · S/N 1061-2008N1642RGrumman American Avn. AA-1B · S/N AA1B0642N178SKCessna 177RG · S/N 177RG1320N2028BCessna 182T · S/N 18280952N21843Mooney M20R · S/N 29-0220N224SGCasey Gary L LANCAIR ES · S/N ES-157N231DTMooney M20K · S/N 25-0206N23CMCirrus Design SR20 · S/N 2466N24NDDodge Norman LONG-EZ · S/N 692265N256GPCessna 172S · S/N 172S9256N26130Grumman American Avn. AA-5A · S/N AA5A0447N29PCCessna 182Q · S/N 18266929N306XZKitty Hawk MULE SPA-ALPHA · S/N 006N309XZKitty Hawk MULE SPA-BETA · S/N 009N314EDCirrus Design SF50 · S/N 0446N3312KGlobe GC-1B · S/N 1305N373DFCessna LC41-550FG · S/N 411009N418TRCessna 340A · S/N 340A1525N445Bell 206B-III · S/N 4285N458CTRaytheon B36TC · S/N EA-661N5097QCessna 310N · S/N 310N-0197N54NYBell Helicopter Textron 206L-1 · S/N 45770N55ZAZee.Aero SPORTSMAN GS-2 · S/N 7427N57LWWestbrook Larry RV-7A · S/N 73476N604ATTim Saxton SR2500 · S/N 060N606WAWisk Aero CX6-1 · S/N 6002001N607WAWisk Aero CX6-1 · S/N 6002002N614WAWisk Aero CX6-1A · S/N 6002003N63EKCirrus Design SR22T · S/N 0943N644DDMooney M20J · S/N 24-0664N6464MDrefs Dwight J RV-10 · S/N 40762N671RACessna 208B · S/N 208B0539N6817BPiper PA-22-150 · S/N 22-4113N69PJCirrus Design SR20 · S/N 9500N6CGCutting C C RUTAN LONG EZ · S/N 310N700MMPatey M/Vision Plane EPIC LT · S/N 010N78909Mooney M20B · S/N 1923N807FECessna 208B · S/N 208B0041Registration pendingN8355JCessna 150G · S/N 15066255N836TSTextron T182T · S/N T18209205N8468CAero Commander 680-E · S/N 680E-802-57N89359Cessna 152 · S/N 15282725N9014PPiper PA-24-260 · S/N 24-4475N91MLLouis J Dietz RV-14 QUICKBUILD · S/N 141428N9328KPiper PA-28R-200 · S/N 28R-7635232N944EBMooney M20R · S/N 29-0111
Back to Mountain View, CA