OpenAirDocs.org
Redlands, CA

Registered aircraft · 98

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

N101LCBellanca 17-31ATC · S/N 31037Built 1972 · Reading Randall CN106TLCessna T182T · S/N T18208215Built 2003 · Burton David HN11099Champion 7ECA · S/N 117Built 1965 · Spee James CN110SAMagnaghi Aeronautica SKY ARROW LSA · S/N LSA029Askalan LLCN11RMBeech B36TC · S/N EA-553Built 1993 · Haig AmyN139LAero Vodochody L-39C · S/N 530523Built 1975 · Grove KarlN1440XPiper PA-24-250 · S/N 24-3478Built 1963 · Alldredge BradN15485Beech B17L · S/N B17L58Registration pendingBuilt 1948N15782Piper PA-28-180 · S/N 28-7305144Crane AustinN1761DSchweizer 269C-1 · S/N 0191Built 2004 · Airwest Helicopters IncN180GGGoral William W GLASAIR SH-2 · S/N 598Built 1988 · Goral William WN180TTMartin PITTS S-1 · S/N 6-7501Built 1979 · Higar Air Service IncN201VEMooney M20J · S/N 24-0395Built 1978 · La Brucherie AndrewN20760Cessna C-165 · S/N 477Spee James CN217ATAllen Thoe VANS RV-14A · S/N 140798Built 2023 · Thoe AllenN241LSStemme S10-VT · S/N 11-064Neff James MichaelN2701ZSchweizer SGS 1-26A · S/N 222Built 1964 · Lessard GeorgeN280CMNorth American T-28B · S/N 137750Higar Air Service IncN28330Grumman American Avn. AA-5B · S/N AA5B0563Built 1977 · Neumayer Barry AN28RKCessna 525 · S/N 525-0111Built 1995 · Rd Aviation LpN2904KPiper PA-28-236 · S/N 28-7911235Krstenansky John LN2WEBell 206-L4 · S/N 52027Built 1993 · We Explore LLCN3050KBeech A36 · S/N E-2364Built 1987 · Walter Jones III Md IncN3073RPiper PA-28R-200 · S/N 28R-35633Built 1969 · Ingraham John W JrN3075XBeech B36TC · S/N EA-466Built 1987 · Orthoredlands Leasing LLCN310MMCessna 310 · S/N 35213Built 1955 · Suhay Richard TrusteeN31HJRobinson Helicopter R22 BETA · S/N 0615Non-citizen corporation, flight hours not reportedBuilt 1986 · Aero Tech Academy IncN322MMCessna T182T · S/N T18208126Built 2002 · River Transport LLCN32454Cessna C-165 · S/N 587Spee James CN3280LCessna 172H · S/N 17256180Dobbertin Thomas EN345MECessna 172S · S/N 172S8577Built 2000 · Ott James EN34757Cessna 177B · S/N 17701983Built 1973 · James David CN350REurocopter AS 350 B2 · S/N 9015Built 2000 · Airwest Helicopters IncN37DRRees SPEZIO DAL-1 · S/N 217Registration pendingN38JPPiper PA-28-181 · S/N 28-7690396Built 1976 · Laymon Kenneth DN390DMCessna 150J · S/N 15070334Built 1969 · Gurrola Joseph CN3928HMooney M20K · S/N 25-0220Registration pendingN401CRColumbia Aircraft Mfg LC41-550FG · S/N 41712Built 2006 · Springrock LLCN4155JPiper PA-28-140 · S/N 28-22751Caton John FN4163WPiper PA-28-181 · S/N 2843127Built 1998 · Redlands Flying ClubN4187DPiper PA-32R-301T · S/N 3257197Arthur RobertN4211XAero Commander 100-180 · S/N 5211Built 1971 · Clyde A RussellN422ABowers Fly Baby 1-A · S/N AMS-01Sherburne Asher JN448JWWilliams J S-12XL AIRAILE · S/N 01JTBuilt 1998 · Williams John T TrusteeN456BCKarl Stewart GOAT · S/N WSGKS001Stewart KarlN48154Fairchild M-62A · S/N T437053Sale reportedBuilt 1943N482SCAero Sport Craft CCK-1865 · S/N CCK-1865-1091Registration pendingBuilt 2025N49HSSchmel Henry J STARDUSTERTOO · S/N 03-123Built 2006 · Sherburne Asher JN501EFHughes Helicopters HUGHES 369D · S/N 270091DBuilt 1977 · Airwest Helicopters IncN5041SPiper PA-28R-200 · S/N 28R-35788Built 1970 · Zelener Howard M
Back to Redlands, CA