Costa Mesa, CA

Registered aircraft · 552

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 = 'COSTA MESA'
  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.

N103JWAnduril Industries CPJ-100 · S/N 71Anduril Industries IncN106AWAnduril Industries ROADRUNNER · S/N 3224Anduril Industries IncN107AAAnduril Industries FALCON · S/N 630Anduril Industries IncN108AWAnduril Industries ROADRUNNER · S/N 3225Anduril Industries IncN108RRAnduril Industries ROADRUNNER · S/N 3119Anduril Industries IncN10957North American OV-10D · S/N 155446Ov10 Squadron LLCN111MTGulfstream Aerospace G-V · S/N 573Built 2000 · Soaring Eagle Ranch LLCN1156MMooney M20K · S/N 25-0642Jays Aircraft Maintenance IncN117RRAnduril Industries ROADRUNNER · S/N 3120Anduril Industries IncN118AWAnduril Industries ROADRUNNER · S/N 3226Anduril Industries IncN119AFGulfstream Aerospace G-IV · S/N 1489Built 2002 · Aviation Sales Associates LLCN120JJGulfstream Aerospace G-IV · S/N 1264Built 1995 · Aviation Sales Associates LLCN121RRAnduril Industries ROADRUNNER · S/N 3121Anduril Industries IncN125JWAnduril Industries BARRACUDA 100 · S/N PTV-08Anduril Industries IncN126JWAnduril Industries BARRACUDA 100 · S/N PTV-09Anduril Industries IncN1287ECessna 172S · S/N 172S10335Built 2006 · Crown Coast LLCN128AWAnduril Industries ROADRUNNER · S/N 3227Anduril Industries IncN130ATDouglas A4D-2N · S/N 12639A-4l LLCN131JWAnduril Industries GHOST · S/N 4430Anduril Industries IncN132RRAnduril Industries ROADRUNNER · S/N 3118Anduril Industries IncN133RRAnduril Industries ROADRUNNER · S/N 3123Anduril Industries IncN134JWAnduril Industries GHOST · S/N 4436Anduril Industries IncN135AWAnduril Industries ROADRUNNER · S/N 3228Anduril Industries IncN138AAAnduril Industries FALCON · S/N 631Anduril Industries IncN1399UCessna 172M · S/N 17267070First renewal noticeBuilt 1976 · Oc 172 Group LLCN141RRAnduril Industries ROADRUNNER · S/N 3124Anduril Industries IncN144RRAnduril Industries ROADRUNNER · S/N 3125Anduril Industries IncN145RRAnduril Industries ROADRUNNER · S/N 3126Anduril Industries IncN149AAAnduril Industries FALCON · S/N 632Anduril Industries IncN149BWAger H/Rega Investments LANCAIR IV P · S/N LIV-373499 Bw LLCN151RRAnduril Industries ROADRUNNER · S/N 3122Anduril Industries IncN15453Rockwell OV-10D · S/N 155409Built 1968 · Ov10 Squadron LLCN156NSRaytheon HAWKER 800XP · S/N 258668Built 2004 · Nunya LLCN158AAAnduril Industries FALCON · S/N 633Anduril Industries IncN161RRAnduril Industries ROADRUNNER · S/N 3127Anduril Industries IncN1648CTextron 172S · S/N 172S11678Built 2016 · Coast Aviation LLCN164PLAnduril Industries ROADRUNNER · S/N 3203Anduril Industries IncN166SPPiper PA-24-400 · S/N 26-79Built 1964 · Switzer James DBAN16854Rockwell OV-10D · S/N 155474Built 1968 · Ov10 Squadron LLCN1726NCessna 120 · S/N 11970Built 1946 · Granneman William LN172BRCessna 172M · S/N 17265776Built 1975 · Oc Flight Lessons LLCN1739JPiper PA-28-140 · S/N 28-24154Built 1968 · Sahli Theodore EN178TLBeaulieu Louis RV-9 · S/N 90398Built 2010 · Beaulieu LouisN181SDBell UH-1V · S/N 74-22482Orange County Sheriffs DepartmentN183SDAirbus Helicopters AS350B3 · S/N 8376Built 2017 · Orange County Sheriff'S DepartmentN184SDEurocopter AS 350 B2 · S/N 4009County Of Orange - Air SupportN185SDAirbus Helicopters AS350B3 · S/N 8125Built 2016 · Orange County Sheriff'S DepartmentN186SDBell UH-1H · S/N 74-22540Orange County Sheriffs DeptN192RRAnduril Industries ROADRUNNER · S/N 3128Anduril Industries IncN19369Cessna 172S · S/N 172S10130Built 2006 · Aci Aviation LLC
Back to Costa Mesa, CA