OpenAirDocs.org
Rocklin, CA

Registered aircraft · 46

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

N1068MCessna 172L · S/N 17259988Built 1971 · Wolfenden Allen KN1174HCessna 182T · S/N 18281145Built 2002 · Geremia FrankN1993BCirrus Design SR22T · S/N 2111Built 2020 · Walton Andrew C TrusteeN19UPRobinson Helicopter R22 · S/N 4574Built 2012 · Bergeson MichaelN20FZSocata TB21 · S/N 644Built 1986 · Sharp Randy LN2174SPiper PA-32-300 · S/N 32-7940054Built 1979 · Barakat Robert HN2182PCessna 182P · S/N 18264767Built 1976 · Siemens Mark JN2265MPiper PA-28-181 · S/N 28-7890238Built 1977 · Eik Baaz LLCN226CVCessna 560 · S/N 560-0226Built 1993 · Massie G2 LLCN2803CCessna 170B · S/N 26346Grant Alison JN2906NCessna 120 · S/N 13167Built 1947 · Schulte Steven PN2915LMooney M20F · S/N 670309Built 1967 · Zorro StephenN3382EAeronca 11AC · S/N 11AC-1708Built 1947 · Farrelly Joseph TN35273Cessna 177B · S/N 17702303Built 1975 · Weltmer Aaron ReeceN37426Interstate S-1A-65F · S/N 271Schulte Steven PatrickN3820SCessna 172E · S/N 17251020Built 1964 · Schrader JeromeN3JXCessna 170B · S/N 25248Built 1952 · Dunbar Marc L TrusteeN421TVCessna 421C · S/N 421C1253Built 1982 · Yuba City Solar Millennium Fund LLCN4531FPiper PA-28R-200 · S/N 28R-7635415Built 1976 · Oneill Robert JN459TMWolter Uli COZY CLASSIC · S/N CC1002Dasmacci FrankN47484Piper PA-28R-201 · S/N 28R-7737165Built 1977 · Sugarbaker Stephen JN48309Ryan Aeronautical ST3KR · S/N 1578Built 1941 · Gottenberg William LN505LMooney M20C · S/N 3171Built 1965 · Shores Robert CN519SGGaitros Scott T MAGNI M16 · S/N 16-09-5494Built 2010 · Owensby Randall SN531PLLewis Paul A KITFOX V · S/N S97120129Built 2006 · Kluenker John KN6173TCessna 150E · S/N 15060873Built 1965 · Great Pilots LLCN6188XCirrus Design SR22 · S/N 0629Korotkov Dmitry VN63910Boeing A75 · S/N 75-3662Built 1942 · Schulte Steven PN6669CBeech AT-11 · S/N 41-27391Built 1941 · Bates Charles EN666EPVans RV-12IS · S/N 121280Built 2021 · Murphy Michael EN6WMCessna 421B · S/N 421B0834Built 1974 · Schrader JeromeN7178EDJI PHANTOM 3 PROFESSION · S/N P76DCG08016648Educational Media FoundationN7455PPiper PA-24-180 · S/N 24-2645Built 1961 · Eagles Aviation LLCN7483ECessna 210 · S/N 57183Built 1960 · Merriman David AN750VPCessna 750 · S/N 7500022Built 1997 · Airelva LLCN758UCCessna R172K · S/N R1723362L&S Adventure LLCN759KPCessna 182Q · S/N 18266057Built 1977 · Sc-Dsc LLCN77744Boeing A75N1(PT17) · S/N 75-777Built 1941 · Gottenberg William LN786BAFritz Bortenlanger RV-8 · S/N 80710Adams Bryan DN8096UBeech C90A · S/N LJ-1326Built 1993 · Whitty Aviation LLCN882CTBeech A36 · S/N E-2566Built 1990 · Charlie Tango Aviation LLCN9178CCessna R182 · S/N R18200437Built 1978 · Kelly Randall ShawnN962SBBeech P35 · S/N D-6844Black Steven CN9637ACessna 140A · S/N 15358Built 1949 · Mutz Paul JN9684WPiper PA-28-140 · S/N 28-23154Gousios Eleni EN993DGDavid M Gardner RV-8 · S/N 80406Built 2021 · Gardner David M
Back to Rocklin, CA