OpenAirDocs.org
Roseville, CA

Registered aircraft · 92

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

N112FSCirrus Design SR22T · S/N 9497Built 2023 · Fl Co-Owners #1 LLCN11446Paul D Cannon KITFOX LIGHT SQUARED · S/N C0203-0277Built 2025 · Cannon Paul DouglasN117DFMooney M20J · S/N 24-1542Built 1985 · Mandell ThomasN122EFHamilton Edward W RV 7A · S/N 70493Built 2008 · Tanber Todd NealN123EVArbc Inc DBA Lindstrand 90A · S/N 5471Built 2010 · Weiscopf Charles WN125CCBurkhart Grob Flugzeugbau G103 TWIN ASTIR · S/N 3710Built 1982 · Silverado Soaring IncN134DBeech A45 · S/N G-743Vac Sys Holdings LLCN18282Textron T182T · S/N T18209136Built 2024 · House John RN182DKCessna TR182 · S/N R18201665Built 1980 · Tonso AntonioN187CTMooney M20J · S/N 24-0776Built 1979 · Koukol Dan FN192DADiamond Aircraft Ind DA20-A1 · S/N 10060Built 1995 · Rhodes Samuel SN1951BCubcrafters CC11-160 · S/N CC11-00429Built 2019 · Plane Fun LLCN20GUSocata TB-20 TRINIDAD · S/N 655Baldree Christian BlairN213EXExtra Flugzeugproduktions EA 300/L · S/N 1213Built 2005 · Halcyon Consulting LLCN21YXPaegelow Christopher D WAIEX B · S/N WXB0021Built 2021 · Paegelow Christopher DN2285DCessna 170B · S/N 20437Built 1952 · Jet Cane CorpN2310QBeech 23 · S/N M-374Built 1963 · Peterson KevinN233EAKratos Unmanned Aerial Systems XQ-58A · S/N 5316158-1Kratos Unmanned Aerial Systems IncN2419DCessna 170B · S/N 20571Built 1952 · Hansen Michael CN241FRTextron T240 · S/N T24002140Built 2017 · Trailside IncN24JDBeech F90 · S/N LA-134Built 1981 · Vac Sys Holdings LLCN2775TBeech V35 · S/N D-8466Warner Jason DavidN2781QCessna 182K · S/N 18257981Built 1967 · Gibboney Phillip MN2816BRans S-14 · S/N 5439394Built 2002 · Hanson Todd AN2875ZPiper PA-28-181 · S/N 28-7990513Pacific Gold Aviation Association IncN3181XCessna 150G · S/N 15064581Built 1966 · Hart GeorgeN3186JCessna 150G · S/N 15065886Built 1966 · Howenstein John GN324AJCirrus Design SR22T · S/N 9963Built 2024 · 324 Aj LLCN3317QCessna 320D · S/N 320D0117Built 1966 · Skynight 17q LLCN340VVCessna 340 · S/N 340-0087Built 1972 · Youth Aviation AcademyN3739WPiper PA-32-260 · S/N 32-653Built 1966 · Pacific Gold Aviation AssociationN3965VMandell Tom CH 601 HDS · S/N 6-3842Built 2010 · Mandell TomN4043JCessna 150G · S/N 15065343Devine Steven AN404VBeech P35 · S/N D-6981Built 1962 · Devine Timothy PN40RMVans RV-12IS · S/N 121430Built 2023 · Mcnaught Ray AN4153CCessna R182 · S/N R18200330Jet Care CorpN427EFFreitag Ernst VANS RV-8 · S/N 80200Built 2002 · Ishii Thomas WN4307HPiper PA-15 · S/N 15-90Built 1948 · Emerson Tiffany AN4309GHanson Todd PPG TRIKE · S/N 001Built 2008 · Hanson Todd AN452DCHylio AG 230 · S/N 17906100254Placer Mosquito And Vector Control DistrictN455PCCirrus Design SR22 · S/N 1961Built 2006 · Pch IncN501TBCessna 501 · S/N 501-0239Built 1978 · Jondu Services LLCN5035SPiper PA-28R-200 · S/N 28R-35766Built 1970 · Ready Airways LLCN522DCCessna 172M · S/N 17263169Built 1974 · Bateson Mark AN5276MCessna 152 · S/N 15284513Built 1980 · Bruehl KennethN527TMMooney M20R · S/N 29-0451Built 2006 · Campbell Air Services IncN5309QCessna 150L · S/N 15073209Built 1972 · Sauvageau Daniel WN540WTTurner Mark D BEARHAWK · S/N 001Built 2026 · Turner Mark DN5446FPiper PA-28-151 · S/N 28-7715139Vander Kooi Chad LeeN5800PPiper PA-24 · S/N 24-880Built 1959 · Cencula Christopher D
Back to Roseville, CA