OpenAirDocs.org
Santa Paula, CA

Registered aircraft · 107

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

N102BDDickinson Gene Steven KR-II · S/N 6816Built 1989 · Dickinson Gene SN106DWWoodruff David L RANS S/6 COYTE II · S/N 0395785ESBuilt 1998 · Stone Mitchel RN107LFLetov LF107 · S/N 53Built 1950 · Mason Samuel AN1141LDJI AGRAS T40 · S/N 5X5BKHS001014ZLimoneira CoN1150LCessna 150L · S/N 15073274Nida Kevin RN117CPAmerican Champion 7GCBC · S/N 1275-99Built 1999 · C P Aviation IncN120LLVans RV-12 · S/N 120118Built 2014 · Hirschman Micah AN1328JRockwell International 112TC · S/N 13038Built 1976 · O'Brien Patrick JN133KJJoe Krybus BU-133 · S/N 1Krybus JoeN156CTFlight Design CTSW · S/N 07-04-11Built 2007 · Sullivan John AN157LBArbc Inc DBA Lindstrand 90A · S/N 5152Built 2001 · Watson-Meinke Peggy LN1592NPiper J3C-65 · S/N 23124Built 1947 · Derwin Lawrence RN1603GChampion 7ECA · S/N 609Built 1968 · Cp Aviation IncN170TXTaylorcraft TAYLOR SPORT · S/N TS-1Built 2005 · Tackabury Jenny AnnN172EPCessna 172N · S/N 17267932Built 1976 · Cp Aviation IncN182WLCessna 182G · S/N 18255802Built 1964 · Mckaye ThomasN1833EChampion AERONCA 7DC · S/N 7DC-5400Built 1946 · Terry Michael R TrusteeN185TKCessna A185F · S/N 18504366Built 1981 · Koff Thomas RN19998Thornhill Tommy A JR VARIEZE · S/N 252Built 1981 · Gottschall Kenneth L IIIN21YCessna 180 · S/N 30837Built 1954 · Cp Aviation IncN230MKBell 230 · S/N 23035Built 1995 · Jkr Distribution LLCN23690Taylorcraft BC-65 · S/N 1424Built 1939 · Mason Michael LN2382SCessna 337B · S/N 337-0682Built 1967 · Mielczarek Joe IN2485KLuscombe 8E · S/N 5212Built 1947 · Kaplan SamuelN25540Porterfield CP-65 · S/N 661Built 1940 · 1940 Porterfield LLCN2596JPiper PA-18-150 · S/N 18-7909121Built 1979 · Markshausen Zeke RN2708MPiper PA-12 · S/N 12-1211Kiceniuk TarasN273MDDickenson Bruce DICKENSONHOWARDDGA21 · S/N 001Built 2008 · Dickenson Bruce E TrusteeN274MDCessna 180J · S/N 18052591Built 1975 · Dickenson Bruce E TrusteeN28082Bellanca 17-30A · S/N 79-30968Built 1979 · Torrey Daniel BN28648Fairchild 24W-40 · S/N W40-148Lombardi Andrew JN30184Cessna 172M · S/N 17264125Built 1974 · Cp Aviation IncN3023SCessna 150G · S/N 15066923Built 1967 · Synnes Dale CN33112Piper J3C-65 · S/N 5830Built 1940 · Mason Peter TrusteeN350YBuhl LA-1 · S/N 139Built 1931 · Kiceniuk Taras JrN35CWind Racer RACER · S/N 104Built 1948 · Dewey James MN360KSSavier Helmut Klaus SAVIER EZ · S/N SEZ-1Built 2010 · Savier Helmut KlausN3946Boeing A75N1(PT17) · S/N 75-1910Built 1942 · Cp Aviation IncN39XPKucki Nick J PITTS S-1S · S/N K-039Built 1976 · Mason SamuelN4162NCessna 120 · S/N 13633Davis ChuckN4164LCessna 172G · S/N 17254233Built 1966 · Derwin Diversified IncN433ACChiavetta Andy LT-1 BOBCAT · S/N 001Chiavetta Andy WN45ZYCzech Aircraft Works Spol Sro MERMAID · S/N 06MM005Built 2006 · Mcwilliams RickN46615Cessna 172K · S/N 17257385First renewal noticeBuilt 1968 · Lindsay William GN4809UCessna 210-5A(205A) · S/N 205-0509Built 1963 · Schutze Curt KN49BRPitts S-2A · S/N 2212Olmsted Aviation LLCN5035NBellanca 8KCAB · S/N 470-79Built 1978 · Cp Aviation IncN50380Bellanca 7ECA · S/N 1291-79Built 1979 · C P Aviation IncN50MHHansen Michael P LONG-EZE · S/N 1403Built 1984 · Wolpin Stephen AN5150ZPiper PA-22-108 · S/N 22-8800Built 1961 · Barilov Yekaterina
Back to Santa Paula, CA