OpenAirDocs.org
El Cajon, CA

Registered aircraft · 195

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 CAJON'
  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.

N1037GTebbe Paul D AVID FLYER MODEL C · S/N 573Mcnamara Douglas SN104MJPitts Acrobatics PITTS S-1T · S/N 1036Lift Drag Aviation LLCN107BZBell 205A-1 · S/N 30013Built 1968 · County Of San DiegoN112TRCirrus Design SR22 · S/N 3669Built 2010 · Bagdasarian Walter DBAN117JABeech 76 · S/N ME-282Built 1980 · Sorbi Aviation IncN119SDDJI AGRAS T100 · S/N 1581F8ZLC25B3002B6F2San Diego Gas & Electric CoN1211SCameron Balloons US PARTY-120 · S/N 6915Built 2021 · Reichert Aviation Enterprises LLCN1294PColumbia Aircraft Mfg LC41-550FG · S/N 41660Built 2006 · Bagdasarian Walter DBAN1324ECessna 172N · S/N 17270956Built 1978 · Sorbi Aviation IncN136HPRaytheon A36 · S/N E-3383Built 2001 · High Performance Aircraft IncN1425XPiper PA-28-151 · S/N 28-7515319Built 1975 · Howell JoshuaN144STStar Anatoly Y ZENITH CH701 · S/N 7-8586Built 2026 · Star Anatoly YN14KPPepiot Kenneth D LANCAIR IV · S/N LIV-128Built 1999 · Grove Robert PN1560WRaytheon A36 · S/N E-3097Built 1997 · High Performance Aircraft IncN165TPiper PA-18-105 SPECIAL · S/N 18-2279Built 1953 · Grove Robert PN18682Fairchild 24R-9 · S/N R9-424Built 1939 · Collins John PN19015Cessna 150L · S/N 15074093Built 1972 · Jackson David WN1926SLearjet 31A · S/N 180Built 1999 · High Performance Aircraft LLCN1943BBoeing E75N1 · S/N 75-8376Built 1943 · Mehrer Fritz JN201NVMooney M20J · S/N 24-0294Built 1977 · Sorbi Aviation IncN20642Schweizer SGS 2-8 · S/N 186530Built 1942 · Clemens Russell EN209EAPipistrel D O O SINUS 912 · S/N 1173 SFNM 912 LSABuilt 2023 · Bierma LawrenceN2151MPiper J3C-65 · S/N 20937Built 1946 · Olstad Christopher AN2160QCessna 172S · S/N 172S9546So Cal Leasing LLCN2219ECessna 172N · S/N 17271189Built 1978 · Sorbi Aviation IncN22524Cameron Balloons ZL-60 · S/N 6562Built 2009 · Reichert Aviation Enterprises LLCN225CMRaytheon B300 · S/N FL-378Mcmillin Sce LLCN2299NCessna 140 · S/N 12539Built 1947 · Ward Worth WN23581Cessna 172R · S/N 17280595Built 1998 · So Cal Leasing LLCN24334Cessna 172R · S/N 17280887Built 2000 · Sorbi Aviation IncN2464HCessna 172S · S/N 172S10049Built 2005 · So Cal Leasing LLCN249GMHarrison Peter G VANS RV9A · S/N 90238Built 2002 · Drinkwine Julie AN24LBeech S35 · S/N D-7503Built 1964 · Sickels Henry CN25860Cessna 152 · S/N 15280825Built 1977 · Sorbi Aviation IncN27915Piper J5A · S/N 5-53Gruner Carl ON280CDCirrus Design SR22 · S/N 1411Built 2005 · Welling Lynn EN284LPCessna 172S · S/N 172S9284Built 2002 · So Cal Leasing LLCN28FUNorth American T-28B · S/N 138164Built 1957 · Bagdasarian Walter DBAN2927VBeech 35 · S/N D-311Hereth Eric WN29942Waco ZPF-7 · S/N 5440Built 1940 · N29942llcN2994ZPiper PA-18-150 · S/N 18-7113Built 1959 · Air Ads IncN3015UPiper PA-28-181 · S/N 28-7990335Built 1979 · Coastal Fliers IncN3056YCessna 182E · S/N 18254056Built 1962 · Bardack Barry L TrusteeN3078MPiper PA-32RT-300T · S/N 32R-7887002Built 1978 · Cartwright Michael R IIN313DPBell Helicopter Textron Canada 407 · S/N 54880Built 2019 · San Diego County Sheriff DeptN315XNCompagnie Daher TB 30 EPSILON · S/N 97Built 1986 · Grove Robert PN3188Boeing B75N1 · S/N 75-2599Built 1945 · Allen Willis M JrN319MWBell Helicopter Textron Canada 407 · S/N 54841Built 2019 · San Diego County Sheriff DepartmentN321LBPiper PA-31T2 · S/N 31T-8166012Built 1981 · Speer Transport LLCN3374GRyan NAVION · S/N NAV-4-1280Built 1948 · Bangle Delbert F
Back to El Cajon, CA