OpenAirDocs.org
Santa Ynez, CA

Registered aircraft · 48

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 = 'SANTA YNEZ'
  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.

N104PTOlson George PITTS S1 · S/N 2Built 1993 · Macomber Donald CN156AECessna 182F · S/N 18254549Built 1962 · Holt Cory JN185FBCessna A185F · S/N 18502580Built 1975 · Burchardi Michael EdwardN185JKCessna A185F · S/N 18503677Built 1978 · Kunkle ChristopherN194AWMorgan Jasper SONEX · S/N 1130Built 2009 · Hangar G-1 Aviaiton Partners LLCN206SXCessna P206B · S/N P206-0316Built 1966 · Laughlin Audio Video Electric IncN2536CCessna 170B · S/N 26180Built 1954 · Libbey EricN2696HCessna 340A · S/N 340A0778First renewal noticeBuilt 1979 · Sunwest Aviation IncN2796NCessna 140 · S/N 13057Built 1947 · Westra John Jacob TrusteeN3010WPiper PA-28-181 · S/N 28-43016Built 1995 · Sunwest Aviation IncN31270Bellanca 7ACA · S/N 68-72Built 1972 · Kunkle James KN36HYAviat A-1B · S/N 2154Built 2001 · Vernon Gregory RN395ECClark Ellis H KITFOX MODEL 3 · S/N 749Murphy Ronald JN4000AWolf Kenneth TRAVEAIR 4000 · S/N 458010422Kunkle James KN420TTolman BUSHBY MUSTANG M-II · S/N M-II-375Victor James AN4319Curtiss Wright TRAVEL AIR 4000 · S/N 372First renewal noticeBuilt 1928 · Noonan DonalN443Dehavilland GIPSY MOTH DH60M · S/N 1325Pacific Southwest Industries IncN443NCurtiss Wright TRAVEL AIR C-4000 · S/N 1344Built 1929 · Pacific Southwest Industries IncN4780LPiper PA-28-180 · S/N 28-4115Built 1967 · Lemon KyleN4963GCessna 172N · S/N 17273510Built 1979 · Sunwest Aviation IncN49681Cessna 152 · S/N 15283495First renewal noticeBuilt 1979 · Sunwest Aviation IncN518TTCessna 525C · S/N 525C0016Built 2010 · Allied Aircraft LLCN544RVMaris Allen P RV-7A · S/N 72995Built 2024 · Maris Allen PN5520GCessna 150J · S/N 15071020Built 1969 · Rm Aero LLCN5525KBellanca 7GCBC · S/N 1025-78Built 1978 · Macomber Donald ConradN558TFLet L 33 SOLO · S/N 030606Romero David MN5EXPiper J3C-65 · S/N 20651Built 1946 · Holt Teri SN5HYSmith SHY SCRAMBALA · S/N 2001Bourgeois Shy SN6094Curtiss Wright TRAVEL AIR 4000 · S/N 598Built 1928 · Noonan DonalN62JXCcx-2300-0046 CCX-2300 · S/N CCX-2300-0046Built 2022 · Payne Jon S TrusteeN63822Piper PA-18-150 · S/N 18-8009023Built 1979 · Coale Douglas AN63823Douglas A Coale PITTS S1S · S/N 0001Coale Douglas AN6387PPiper PA-24-250 · S/N 24-1497Built 1959 · Brundidge Neil DN68BKCessna T182T · S/N T18208398Built 2005 · Krauch William K Co-TrusteeN6999JPiper PA-28R-200 · S/N 28R-7635373Built 1976 · Sun West Aviation IncN70JPRobinson Helicopter R44 II · S/N 14795Built 2024 · Payne Jon S TrusteeN7174HPiper J3C-65 · S/N 20435Built 1946 · Moore Brennan CN71JPGame Composites GB1 GAMEBIRD · S/N 0064Built 2023 · Payne Jon S TrusteeN72PVBeech A36 · S/N E-2452Built 1988 · Bowman Theodore RN75162Piper PA-28-151 · S/N 28-7615261Built 1976 · Mccann Michael HN800TBMooney M20J · S/N 24-1514Built 1984 · Hamaoui NessN8179Curtiss Wright TRAVEL AIR 4000 · S/N 972First renewal noticeBuilt 1929 · Pacific Southwest Industries IncN82505Piper PA-18-150 · S/N 18-7809182Built 1978 · Kunkle ChristopherN848HDavis V-3 · S/N 106Built 1929 · Bourgeois Shy TrusteeN8810XCessna 182D · S/N 18253210Laughlin Robert LN900CStinson 108-3 · S/N 108-3900Built 1947 · Romero David MN909JHHeadrick James RV9A · S/N 91305Built 2008 · Shean Thomas RN921FTEiriavion PIK 20D · S/N 20514Macomber Donald C
Back to Santa Ynez, CA