OpenAirDocs.org
Alpine, CA

Registered aircraft · 28

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N177FGCessna 177 · S/N 17700817Built 1968 · Mancini JosephN1947HAero Z BUECKER 131 · S/N 185Built 1947 · Hickman Gary WayneN2192Bell 206B · S/N 2192Built 1977 · Flyers Enterprises IncN22823Bell 206B · S/N 3635Built 1983 · Steve Wright Enterprises IncN256XADJI AGRAS T40 · S/N 1581F574B234U00100M9Agriculture Technologies IncN273SAIniziative Industriali Italian SKY ARROW 650TCN · S/N CN005Built 1999 · Everingham Roy Robert JrN31CNCessna 172N · S/N 17267936Built 1976 · Skyland Aviation LLCN4389XPiper PA-28R-200 · S/N 28R-7635034Built 1975 · Rrg Software LLCN458BBeech 35 · S/N D-1475Built 1948 · Swensson Sean CN501QJDJI AGRAS T50 · S/N 1581F6BUB233J00101NFAgriculture Technologies IncN5322XPiper PA-28-181 · S/N 2843483Built 2001 · Rodriguez Robert HN57005Boeing A75N1(PT17) · S/N 75-694Built 1941 · Arnold Matthew CN5LHCessna 310Q · S/N 310Q0939Built 1973 · Island Creek Partners LLCN6169PPiper PA-24-250 · S/N 24-1270Built 1959 · Klier John MN63128Wecker Richard C WECKER ACRO TRAINER · S/N 1Built 1998 · Crutchfield Richard EN64RBCessna 182L · S/N 18258811Built 1968 · Burnett Ramon RN691MAPiper PA-32R-301T · S/N 3257291Built 2002 · Mitchell MartinN7103SCessna 150H · S/N 15067803Built 1967 · Hammerstrand John LN711DCCessna 170A · S/N 20144Built 1951 · Dufford Michael WN733NCCessna 172N · S/N 17268411Built 1976 · Rrgsoftware LLCN7372PPiper PA-24-250 · S/N 24-2553Built 1961 · Arnold Matthew CN738RFCessna 172N · S/N 17270173Built 1977 · Severe Clear Aviation LLCN81916Piper PA-28-161 · S/N 28-8016311Built 1980 · Rrg Software LLCN9310WPiper PA-28-235 · S/N 28-10990Built 1967 · Gb Aviation LLCN9338RCessna TR182 · S/N R18200693Built 1978 · Meshinsky JeffreyN9358AMeloche Michael BCKR JUNGMN-MELOCHE · S/N 001Meloche Michael SN94946Cessna 182Q · S/N 18266544Built 1978 · Van Duzer John PN9757EAeronca 11AC · S/N 11AC-1400Built 1946 · Inspired Oasis LLC
Back to Alpine, CA