OpenAirDocs.org
Rosamond, CA

Registered aircraft · 99

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

N10BCCub Crafters CC11-100 · S/N CC11-00087Built 2009 · Yaberg Thomas LN11345Cessna T206H · S/N T20608668Built 2006 · Enviroplus Consulting IncN11HGDube Alfred THORP T-211X · S/N 015Built 2003 · Shooting Star Services LLCN122RWWise Ralph GT400 · S/N GT001Built 2004 · Shick Kenneth WN133SVMetzler Kevin W VELOCITY STD RG · S/N SFE 012Metzler Kevin WN13574Cessna 195 · S/N 7108Warner Aric DN13PZMaule MX-7-180A · S/N 20002CBuilt 1994 · Croft JordanN144RVGross Richard E RV-6 · S/N 1First renewal noticeBuilt 1991 · Tanner Roger JN1462DCessna 170A · S/N 20045Warner Aric DN15462Cessna C-34 · S/N 301Warner Aric DN1702BBoeing PT-13D · S/N 75-5903Built 1942 · Kenefick Christopher KN174TYYaberg Thomas L VANS RV7A · S/N 70331Built 2004 · Yaberg Thomas LN182STCessna 182K · S/N 18258051Built 1967 · Rose David HughN18TLCessna 182L · S/N 18259225Carey Nicolas JN18WJJennings William L THORP T-18 · S/N 464Ogan Michelle LN1977CCessna 170B · S/N 26122Built 1953 · Berquam PaulN1GUForney F-1 · S/N 5610Built 1957 · Habbal WissamN2088BPiper PA-28-161 · S/N 28-7916108Built 1978 · General Aviation Support CorpN20ABSchleicher ASW-20 · S/N 20338Built 1980 · Tanner Roger JN211XHHaun James J THORP T211 X · S/N 001Built 2000 · Habbal WissamN2307Cessna 172P · S/N 17274920General Aviation Support CorpN2363NPiper PA-38-112 · S/N 38-79A0809Non-citizen corporation, flight hours not reportedGeneral Aviation Support CorpN2554HSchweizer SGS 1-26E · S/N 654Zeller Francis JN25ESCessna 172N · S/N 17269082Built 1977 · General Aviation Support CorpN271JGreene Jay R LONG EZ · S/N 271Built 1994 · Goossen Luke AN28TGGinn Anthony E THORP T-18 · S/N 281Built 1992 · Shooting Star Services LLCN3095DCessna 310 · S/N 35295Built 1956 · Irvine William GN31BDDial Robert M THORP T-18 · S/N 354Built 1983 · Maisler Brian DN325RHRoger Hensley LANCAIR 320 · S/N 543-320-290Built 2016 · Hensley Roger AN328DHVaughan Bobby F VANS RV-8 · S/N BV001Built 2004 · Brown Kevin EN333VMDembs Jon COZY MARK IV · S/N 973Built 2008 · Blackbird Enterprises LLC DBAN334YCessna 180F · S/N 18051299Warner Aric DN37887Borremans Richard J OSPREY-2 · S/N 112Built 1982 · Metzler Kevin WN3854XAero Commander 100 · S/N 146Built 1967 · Applegate Ronald EN3YMHanson Frederick A GLASAIR III · S/N 3223Built 2001 · Loftin Scott MN4009PPiper PA-23-160 · S/N 23-1484Built 1958 · Applegate Ronald EN407HRCrockett Parker GLASAIR 1 RG · S/N 407Built 1991 · Loftin Scott MN40CZCanedy Clark COZY MK IV · S/N 0763Beast Aero Consulting And Training LLCN4123PFlight Design CTLS · S/N F-13-12-10Built 2012 · Broce Donald SN4136HPiper PA-15 · S/N 15-19Built 1948 · Metzler Kevin WN4181EAeronca 11CC · S/N 11CC-82Shooting Star Services LLCN42BLLindeke Robert L RV-4 · S/N 2899First renewal noticeBuilt 2003 · Rainey Steven MN446DHYakovlev YAK-50 · S/N 853106Built 1985 · Glaser Scott TN4518RPiper PA-28-140 · S/N 28-21220First renewal noticeBuilt 1965 · Edmondson William AN459JDBeech A36 · S/N E-210Built 1970 · Wilson John KN45TJRyan NAVION A · S/N NAV-4-1863Built 1949 · Applegate Ronald EN4732VCessna 172RG · S/N 172RG0371Built 1980 · General Aviation Support CorpN4750PPiper PA-23-250 · S/N 27-288Built 1960 · Kenefick Christopher KeithN4782GLuther Sunderland THORP T-18 · S/N 77Built 1968 · Seguin ElliotN48768Cessna 152 · S/N 15283371General Aviation Support Corp
Back to Rosamond, CA