OpenAirDocs.org
Auburn, CA

Registered aircraft · 108

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

N11179Cessna A185F · S/N 18504436Built 1985 · Holloway DavidN1141MCessna 172L · S/N 17260152Sunshine FlyersN11693Bellanca 7ECA · S/N 853-72Miller Robert AN1306CCessna 172S · S/N 172S10655Built 2007 · Wateractive43 LLCN1406TPiper PA-28R-200 · S/N 28R-7235280Built 1972 · Citabria IncN14QWCessna 182T · S/N 18281760Built 2006 · Dinucci MarioN16417Piper PA-28-180 · S/N 28-7305249Built 1973 · Riddle Christopher JosephN17200Cessna 150L · S/N 15073659Built 1972 · Horton Andrea LN1851APiper PA-31-310 · S/N 31-7812030Built 1977 · Placer County Sheriffs DepartmentN200JJMaule MXT-7-180A · S/N 21012CVeblen RaakN20162Cessna 310Q · S/N 310Q-1004Built 1974 · Wateractive43 LLCN201BAMooney M20J · S/N 24-1013Built 1980 · Justus Richardson Toby TygheN204SLSchweizer 269C-1 · S/N 0023Bethesda Family LpN2156RCessna 182G · S/N 18255356Built 1964 · Winfrey Walter A TrusteeN222GBSmith AEROSTAR 601P · S/N 61P-0255-047James David L DBAN24261Cessna 152 · S/N 15280181Built 1977 · Citabria IncN24ZMMelnik Laura KITFOX SER 5 · S/N S9507-140Foster Daniel AN252TBMooney M20K · S/N 25-1110Skyview Global LLCN260GFHawker MK 11 SEA FURY · S/N 41H636334Ellsworth Hovey Getchell Foundation IncN2680FCessna 182J · S/N 18256780Built 1965 · Watkins Jeffrey MN2852QCessna 172L · S/N 17259852Built 1971 · Millard Randy WN28747Grumman American Avn. AA-5B · S/N AA5B0790Built 1978 · Vogt Gary LN28GBellanca 7KCAB · S/N 434-74Built 1974 · Mooneyham MarkN290MMBatchelor Mark S THORP T-18 · S/N 001Built 2001 · Batchelor Mark SN310RRCessna 310R · S/N 310R0014Built 1974 · Wateractive43 LLCN316MECirrus Design SR22T · S/N 2204Built 2020 · Hyperspeed Aviation LLCN3318QCessna 320D · S/N 320D0118Built 1966 · 2400 Rickenbacker LLC DBAN3470JCessna 150G · S/N 15066170Edson VincentN35FCMooney M20R · S/N 29-0369Transonic IncN3846LCessna 172G · S/N 17254015Built 1966 · Elicker Sheldon LN3866PPiper PA-22-150 · S/N 22-3558Built 1955 · Wateractive43 LLCN3948QCessna 172L · S/N 17260048Built 1971 · Citabria IncN4065RPiper PA-32-300 · S/N 32-40373Built 1967 · Dever BrandonN412EVEvektor-Aerotechnik SPORTSTAR · S/N 20050412Built 2005 · Citabria IncN421JLCessna 421C · S/N 421C0210Built 1977 · Wagner Distributing Co IncN421YPCessna 421B · S/N 421B0511Wateractive43 LLCN430TSDiamond Aircraft Ind DA 42 · S/N 42.AC030Built 2006 · Wateractive43 LLCN4364EAeronca 7EC CONV · S/N 25Built 1948 · Langley AaronN441MPSmith Brent MINI-IMP-C · S/N 002Built 2022 · Smith BrentN444FCessna T210M · S/N 21061686Registration pendingBuilt 1977N44649Piper PA-28R-200 · S/N 28R-7435319Built 1974 · Wofford Walter RN4485North American SNJ-6 · S/N 44-81646-1Built 1944 · Dwelle Thomas AN46924Aeronca 0-58B · S/N 058B8443Built 1945 · Dwelle Kenneth HN470PJVans RV-12 · S/N 120120Built 2016 · Flippin Dale FN4849APiper PA-22-150 · S/N 22-4002Built 1956 · Veblen RaakN5115BCessna 172S · S/N 172S8987Wateractive43 LLCN513SJCessna 421C · S/N 421C0043Built 1975 · Wagner Distributing Co IncN5231XChampion 7KCAB · S/N 209Built 1969 · Holloway David GN5288WPiper PA-28-160 · S/N 28-338Built 1962 · Mcdowell John MichaelN530AUCessna 172S · S/N 172S9225Wateractive43 LLC
Back to Auburn, CA