OpenAirDocs.org
Upland, CA

Registered aircraft · 102

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

N101ERCessna 560XL · S/N 560-6179Built 2014 · Rl Trasnportation Co Ix LLCN1108WRaytheon B36TC · S/N EA-611Built 1998 · Etemadian AliN1182ACessna 182P · S/N 18264009Built 1975 · Aero-Flyte Of Pomona IncN1191Aviat PITTS S-2B · S/N 5284Vmc Aviation IncN12897Cessna 172M · S/N 17262352Built 1973 · Foothill Aircraft Sales & Service IncN1444FCessna 172H · S/N 17254939Built 1966 · Strope Byron PN1490ECessna 172N · S/N 17271020Built 1978 · Foothill Aircraft Sales & Service IncN150AHKoliber PZL-150A · S/N 03930058Registration pendingBuilt 1993N15173Stinson SR-7B · S/N 9653Built 1937 · Ciabattoni Joseph LN172MPCessna 172C · S/N 17248976Built 1961 · Passwater Michael EN172TWCessna 172 · S/N 29537Built 1956 · Griffiths Larry FN183JRRausch John RV-8 · S/N 80110Built 2009 · Rausch John CN184EWaco UPF-7 · S/N 5603Built 1941 · Ciabattoni Joseph LN2041DBeech C35 · S/N D-3393Built 1952 · Lyman Eric JN2057YCessna 172D · S/N 17249557Built 1962 · Cable Land CoN21302Cessna 182P · S/N 18261549Blackburn James EN2186NCessna 140 · S/N 12422Built 1947 · Aircraft Ground Support IncN2272RCessna T210J · S/N T210-0422Built 1969 · Berntsen KurtN22HGBeech F33A · S/N CE-1102Freeno JosephN241MAAviat A-1C-180 · S/N 3110Built 2010 · Kim Sung Su TrusteeN25590Porterfield CP-65 · S/N 696Cable Robert AN2914FCessna 182J · S/N 18257014Built 1965 · Harris ZadokN2951HErcoupe 415-C · S/N 3576Built 1946 · Onderdonkrichard PN2955HEngineering & Research ERCOUPE 415-C · S/N 3580Built 1946 · Lindsey NicholasN3012SCessna 150G · S/N 15066912Built 1967 · Marshe Aviation LLCN3022ECessna 182R · S/N 18268227Built 1982 · Boulais AaronN316JDMartinez John F RV-4 · S/N 649Martinez StevenN3563LCessna 150F · S/N 15062363Built 1965 · Martinez Guillermo EN3647DCessna 310 · S/N 35347Vmc AviationN3670LCessna 172G · S/N 17253839Built 1965 · Latch Leo DN37895Northwestern PORTERFIELD CP-65 · S/N 1025Built 1941 · Bergen Jerri LN3928BCirrus Design SR22 · S/N 0917Built 2004 · Kellner EricN400XWXiru Wang YUNEEC E-430 · S/N E430 CY-E2-8Registration expired, pending cancellationBuilt 2013 · Xiru WangN40792Piper J4E · S/N 4-1602Built 1941 · Schulz Michael AlanN411RFCessna 172F · S/N 17252216Foothill Aircraft Sales & Service IncN422GRBeech V35 · S/N D-8243Built 1966 · Holden Virgil Gary TrusteeN4290BBeech F35 · S/N D-4253Built 1955 · Delyser Dwight GN4410BCessna 170B · S/N 26754Built 1955 · Rhymes Dustin AN4438CCessna 195B · S/N 16023Built 1953 · Ciabattoni Joseph LN446PBeech A36 · S/N E-2835Built 1993 · Morris Danny JN4511ZPiper PA-22-108 · S/N 22-8013Built 1960 · Kim AndrewN4544TPiper PA-28R-200 · S/N 28R-7235085Built 1972 · Jdc Aviation LLCN45740Luscombe 8A · S/N 2267Built 1946 · Ducut Justin JosephN464SRBeech E33A · S/N CE275Harris Bryan CN47HMHarris David M VANS RV-7A · S/N 74610Built 2020 · Harris David MN4943WRockwell International 114 · S/N 14265Kaufman Michael AN50NTAirbus Helicopters AS350B3 · S/N 9433Built 2023 · City On OntarioN5107SPiper PA-28R-200 · S/N 28R-7135108Built 1971 · Jdc Aviation LLCN5161PPiper PA-24-250 · S/N 24-177Built 1958 · N5161p LLCN5283MBeech 76 · S/N ME-25Built 1978 · Pskd Limited LLC
Back to Upland, CA