OpenAirDocs.org
Carlsbad, CA

Registered aircraft · 141

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 = 'CARLSBAD'
  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.

N105UCCessna 152 · S/N 15285998Built 1985 · Stem Aviation AcademyN1066BPiper PA-32R-301T · S/N 3257443Built 2006 · Wexhler David R TrusteeN107MCPiper PA 46-350P · S/N 4636609Built 2013 · Veratix Ventures LLCN10KYCessna A185E · S/N 18501898Built 1971 · Mckinnon Laughlin Neil TrusteeN1139PMooney M20J · S/N 24-1153Built 1981 · Bieler Robert AN123WSSanders Leon Wayne VANS RV-6A · S/N 20501Built 2008 · Bibb BenjaminN1269SCessna 182P · S/N 18264837Mriaudio IncN1400Cessna P210N · S/N P210-00277Built 1979 · Salour Michael MN141MBDunn Gregory L RV-7A · S/N 73719Built 2022 · Dunn Gregory LN14DXGerdes Dan R RV-14A · S/N 140444Built 2020 · Gerdes Dan RN151HAirbus Helicopters AS 350B3 · S/N 9647Built 2024 · Hangar One Avionics IncN1565ZBeech P35 · S/N D-6867Built 1961 · Stowe Martin DN164KWWilliamson Kevin VANS RV-6 · S/N 20080Williamson Kevin DN1698VCessna R172K · S/N R1722209Built 1976 · Stem Aviation AcademyN1763MCessna 182P · S/N 18264429Built 1975 · Haines Robert FN1783GBeech 35-B33 · S/N CD-521Built 1962 · Harrington Perry JN1873CCessna 170B · S/N 26017Built 1953 · Orion Aviation Aircraft LLCN18998Beech V35B · S/N D-10073Built 1977 · Duffer Management LLCN18MKAmerican Legend AL3 · S/N AL-1084Built 2007 · Stenzel John DN200FWGrumman American Avn. AA-5B · S/N AA5B-0194Built 1975 · Nextwerk IncN205RWMooney M20J · S/N 24-3052Garratt Tyler TrusteeN205WFJihlavan Airplanes Sro KP5 · S/N 5109127KBuilt 2005 · Swovelin Jerry LN21JVWay PITTS S-1 · S/N 137Built 1977 · Matula John KN22754Cessna 172M · S/N 17264076Built 1974 · Gomez Abigail SN2319PPiper PA-22-150 · S/N 22-2730Built 1955 · Mood Kathleen TN231GBDouglas DC3C 1830-94 · S/N 26108Built 1944 · Hanks Thomas MN2381ZCessna 172R · S/N 17281276Built 2005 · Leone Brighter Developments LLCN2388Boeing E75 · S/N 75-8077Built 1943 · Beliveau Richard AN247DEConner Jeff VANS RV-7A · S/N 70985Built 2005 · Ktor LLCN2504WCopeland Glen Nolan RV-6 · S/N 22839Bade Russell EN2524KCessna 180K · S/N 18052969Built 1978 · Ganz Brian LN2769TBeech V35 · S/N D-8477Built 1967 · Rakhmatulin Evgeny AN30069Piper PA-32-300 · S/N 32-7840195Built 1978 · Sky Pilot Aviation CorpN305PACirrus Design SR20 · S/N 9834Built 2024 · Palomar Aviation LLCN306KCCirrus Design SR22 · S/N 0253Best Flight LLCN333KHIai GULFSTREAM G280 · S/N 2094Built 2016 · Zzz Aviation LLCN33WZJohn F Rowen III RV-10 · S/N 43052Rowen John IIIN345LCGulfstream Aerospace GV-SP (G550) · S/N 5145Built 2007 · N276gc LLCN347TACostruzioni Aeronautiche Tecna P2008 · S/N 201Built 2021 · Fallone Robert CarlN3515YCessna 182E · S/N 18254415Inflyt LLCN3652JCessna 150G · S/N 15064952Built 1966 · Jet Boy LLCN371CWSocata TBM 700 · S/N 371Built 2006 · Lpv Holdings LLCN3755KGlobe GC-1B · S/N 1448Registration pendingN3829NBeech 35 · S/N D-1066Built 1947 · Costello John J JrN3905QCessna 172L · S/N 17260005H&H Cloudbase Aviation LLCN393SGCessna 525B · S/N 525B0377Built 2012 · N393sg LLCN417KRaytheon A36 · S/N E-3269Built 1999 · Kinsley Joshua P TrusteeN427DSCostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 285Built 2007 · Schilke David DN4360FPiper PA-28-181 · S/N 28-7790022Built 1976 · North County Flight Training IncN450EJGulfstream Aerospace G-IV · S/N 1273Built 1995 · Premier Air Charter Inc
Back to Carlsbad, CA