Menlo Park, CA
Registered aircraft · 63
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 = 'MENLO PARK' 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 = 'MENLO PARK' 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.
N11308Cessna 150L · S/N 15075317N122AJCirrus Design SR22 · S/N 1547N122JMPilatus PC-12/47E · S/N 1523N13QACirrus Design SR22T · S/N 2099N182CPCessna 182Q · S/N 18267483N1857Cirrus Design SR20 · S/N 1298N196XIsrael Aerospace Industriesltd G200 · S/N 196N1CUBombardier CL-600-2B16 · S/N 5890N2027RCessna 182G · S/N 18255227N208LJRobert Eustace / Tony Rasch SR AIRCAM · S/N AC155N21BQCirrus Design SR22T · S/N 1284N220RPBeech A36 · S/N E-2438N22CHCessna T206H · S/N T20608101N245BDGulfstream Aerospace GV-SP (G550) · S/N 5165N2504KSilvaire LUSCOMBE 8 · S/N 5231Registration pendingN280AEnstrom Helicopter 280C · S/N 1210N285CRaytheon A36 · S/N E-3477N288TSCirrus Design SR20 · S/N 2763N29PGDiamond Aircraft Ind DA 40 · S/N 40.341N308LJCessna 680 · S/N 680-0109N30CEConterno J/Pfeifer R SUPER EAGLE · S/N 0001N318YGCompagnie Daher TBM 700 · S/N 1342N31JAQuest KODIAK 100 · S/N 100-0042N324WKIsrael Aircraft Industries GULFSTREAM 200 · S/N 108N333STArthur Van Hoff SLING TSI · S/N 196SKRegistration pendingN34MVPiper PA-32R-301 · S/N 32R-8413006N393RGRichard A Gottscho CCX-2300 · S/N CCX-2300-0071N4175KPiper PA 46-350P · S/N 4636294N458GRHylio HYL-300 · S/N 17906130213Sale reportedN4722APiper PA-18A 150 · S/N 18-4943N494KCPilatus PC-12/47E · S/N 1494N4WRBeech V35 · S/N D-8497N5062GBellanca 7ECA · S/N 1325-79N508LJParagon Space Development 63001 · S/N 0001N525MGPiper PA-32R-301T · S/N 3257118N545DGCirrus Design SR22T · S/N 2072First renewal noticeN557KNHylio HYL-300 · S/N 17906130216Sale reportedN57PABeech B200 · S/N BB-1444N5978PPiper PA-24-250 · S/N 24-1071N604SBBombardier CL-600-2B16 · S/N 5569N6051ECessna R182 · S/N 18268342N61HWCirrus Design SF50 · S/N 0469N6201UCessna T206H · S/N T20608881N667DJDevon Joos MURPHY MOOSE · S/N 193SRN689BGGulfstream Aerospace GVI (G650ER) · S/N 6577N704BLDiamond Aircraft Ind DA 40 NG · S/N 40.NC264N70MCTextron G36 · S/N E-4089N7218RBeech A36 · S/N E-616N737YKCessna R182 · S/N R18200895N788AKJohannes Noordwijk RV-14A · S/N 140261
Back to Menlo Park, CA