El Segundo, CA
Registered aircraft · 47
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 = 'EL SEGUNDO' 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 = 'EL SEGUNDO' 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.
N110SXRobinson Helicopter R44 II · S/N 12328N112LTCessna 208B · S/N 208B1037N119RPCirrus Design SR20 · S/N 2457N12NGBeech 200 · S/N BB-581N141LCDJI FLYCART 30 · S/N 1581F7C6B23AS0018077N15XJPiper PA 46-350P · S/N 4636796N2084DFitzbag Dean VELOCITY SRG · S/N SRG061N23NGCessna 680 · S/N 680-0527N259BHHerron King D GLASAIR SH2 R · S/N 655RN260JSIAI Marchetti F.260C · S/N 736N278MHAviat A-1C-180 · S/N 3400N27RAGulfstream Aerospace G-V · S/N 543N291PABeech 200 · S/N BB-291N326JGNorthrop Grumman Systems H03 · S/N 00001N37NGGulfstream Aerospace GV-SP (G550) · S/N 5580N37WHGulfstream Aerospace G-IV · S/N 1243N38NGGulfstream Aerospace GV-SP (G550) · S/N 5527N391ZAAero Vodochody L-39 · S/N 132015N404PGCessna 525B · S/N 525B0305N4702BBell Helicopter Textron Canada 407 · S/N 54102N472VBBell Helicopter Textron Canada 407 · S/N 54115N498WTStout Garry V RV-7A · S/N 72514N5082VVarga 2150A · S/N VAC-71-77N518DFNorthrop Grumman Systems R03 · S/N 00001N52946Cessna 177RG · S/N 177RG1317N53HKCompagnie Daher TBM 700 · S/N 1508N580FLPiper PA-28-140 · S/N 28-7125433N620RDDiamond Aircraft Industries GM DA 52X1 · S/N 52.001N623SWBoeing 737-3H4 · S/N 27933N649SELearjet 60 · S/N 390N66TECessna P210N · S/N P21000154N716BENorthrop Grumman Systems R03 · S/N 00002N72NGTextron B300 · S/N FL-1047N731VGPiper PA46-500TP · S/N 4697326N7336NCessna 182P · S/N 18263120N74NGTextron B300 · S/N FL-1053N77NGTextron B300 · S/N FL-1048N804XBombardier CL-600-2C10 · S/N 10002N805XBombardier CL-600-2C10 · S/N 10091N806XBombardier CL-600-2C10 · S/N 10008N8099HBeech A36 · S/N E-2743N8603MBeech 35-B33 · S/N CD-658N872WAPiper PA-28R-201T · S/N 28R-7703182N8898QCessna TU206G · S/N U20603561N9263JPiper PA-28-180 · S/N 28-3339N984HADehavilland DHC-8-106 · S/N 377N99NGGulfstream Aerospace G-V · S/N 501
Back to El Segundo, CA