Escondido, CA
Registered aircraft · 65
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 = 'ESCONDIDO' 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 = 'ESCONDIDO' 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.
N11259Waco RNF · S/N 3462N123NKBeech A60 · S/N P-153N129PLCirrus Design SR22T · S/N 0651N135CEBeech F33A · S/N CE-1356N142BGStanford Jeff SUPER ES · S/N ESJS01N1625JPiper PA-28-140 · S/N 28-24818N171HPPiper PA46-500TP · S/N 4697371N182DMCessna 182P · S/N 18262783N187RVIngram/Baker RV-4 · S/N 405N190DLPiper J3C-65 · S/N 15287N200HLDave Leedom DAL01 · S/N 01N20605Cessna 180K · S/N 18053199Registration pendingN209DBMesserschmitt-Bolkow-Blohm BO 209 MONSUN · S/N 139N213CDCirrus Design SR20 · S/N 1111N2191GBalloon Works FIREFLY 6B-15 · S/N F6B-2001N21NSNemyo Thomas SA 300 · S/N 422N226KPJihlavan Airplanes Sro KP5 · S/N 5107124KN23WGPiper PA-23 · S/N 27-565N243SXRobert H Wilson SONEX · S/N 0243N245MBBellanca 17-31ATC · S/N 78-31140N269HPLearjet 31A · S/N 161N270MZVans RV-12 · S/N 120616N2908SCessna 150G · S/N 15066808N29BMMclendon Bobby Lee VARIEZE · S/N 1429N307DTKeith Butler ELA ECLIPSE 10 · S/N 07175391014N331MDJames M Doss VANS AIRCRAFT RV-9 · S/N 90991N3722UCessna 182G · S/N 18255122N4058RPiper PA-32-300 · S/N 32-40363N420BJJohannes Robert D JOHANNES-ACRO SPT II · S/N 42N4272RPiper PA-32-300 · S/N 32-40647N435MSGates Lear Jet 35 · S/N 054N4446SRon Struble AG-915 CENTURION · S/N AGML004-915CN4937NBoeing A75N1(PT17) · S/N 75-8609N5070KBeech A45 · S/N G-65N5676VPiper PA-28-181 · S/N 28-7790494N56SEWiza Joseph D RV-6A · S/N 24682N58567DJI AGRAS T25 · S/N 1581F6BUB23AU001215WN58PFBeech 58 · S/N TH-888N6016UBeech 76 · S/N ME-156N621DFDavid B Finck RV12 · S/N 120386N6505GCessna 150L · S/N 15072005N664RWMBL Classics SP Z O O AG915 JAVELIN · S/N MC.E.21.P.5.G.15.AA.007.LN676KVVernon W Roach URBANE FLYER 30 MKII · S/N 0001N67WSSchempp-Hirth DISCUS A · S/N 8N732JJCessna T210L · S/N 21061546N737DLCessna 172N · S/N 17269337N7415QBalloon Works FIREFLY 7 · S/N F7-335N74932Piper PA-31-350 · S/N 31-7305074N761DNCessna T210M · S/N 21062175N76TJEvaul Robert W RV-6A · S/N 21675
Back to Escondido, CA