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.

N504EFMcdonnell Douglas Helicopter 369E · S/N 0500EAirwest Helicopters IncN50BSGlobe GC-1B · S/N 1118Built 1946 · Sugiono Yudi SN534CPCirrus Design SR22 · S/N 3035Built 2008 · On Duty Health - Texas PllcN5387CCessna 140A · S/N 15520Built 1950 · Goral William WN542TBeech N35 · S/N D-6718Built 1961 · Hoel Erik GerhardN55386Socata TB 9 TAMPICO · S/N 1189Redlands Flying ClubN5603JCessna 182P · S/N 18263460Built 1974 · Miller Duane AN568RVNeumayer Ba/Cheesman WC RV-8 · S/N 81000Built 2009 · Neumayer Barry AN5716DPiper PA-22-150 · S/N 22-4412Built 1956 · Neumayer Barry AN5735QMooney M20E · S/N 726Built 1965 · Beler Arnold Ray IIN5832LAmerican AA-5 · S/N AA5-0232Built 1972 · Plesea LucianN5879CBeech C35 · S/N D-2835Built 1951 · Skeen Nikki BN5943TCessna 150D · S/N 15060643Built 1964 · Mission Flight AcademyN603XDDJI PHANTOM 3 STANDARD · S/N P5ADCG230600GFDe Franco Aaron MN6114SCessna TR182 · S/N R18201616Built 1980 · Goral William WN6133CBell 206L-3 · S/N 51544Built 1991 · Redlands Heli Flight LLCN62PECessna 510 · S/N 510-0363Built 2011 · Impulse Circulation Services IncN664RVJohn T Williams RV-10 · S/N 41359Built 2018 · Williams John T TrusteeN66517Cessna 150M · S/N 15076095Built 1974 · Sugiond Yudi SN6975CNorth American AT-6G · S/N 51677Sale reportedBuilt 1958N7197ZRobinson Helicopter R22 BETA · S/N 3249Non-citizen corporation, flight hours not reportedBuilt 2001 · Aero Tech Academy IncN7235WPiper PA-28-180 · S/N 28-1054Built 1963 · Morris GeorgeN737GPCessna 172N · S/N 17269409Built 1977 · Williams Allen EN74505Mooney M20B · S/N 1816Registration pendingBuilt 1961N7769Root Erwin L SA300 STRDSTR TOO · S/N SN001LRBuilt 1997 · Sherburne Asher JN777CWPiper PA-28-181 · S/N 28-7890233Built 1977 · Keidel Mark TN80300Cessna 172M · S/N 17266506Ryther Jonathan WN81724Aeronca 7AC · S/N 7AC-343Built 1945 · Spee JamesN8233DBeech J35 · S/N D-5335Tangobravo Consulting LLCN828WTRaytheon A36 · S/N E-3581Laymon Air LLCN8525YHughes OH-6A · S/N 67-16493Built 1969 · Grove Karl PN8571MBeech 35-B33 · S/N CD-645Super Richard C IIN861LBLindstrand Balloons 35A · S/N 5430Walsh Daniel PN8628BCessna 172 · S/N 36328Scarcella Joseph AN8632ZCessna TP206C · S/N P206-0432Tate RogerN8720PPiper PA-24-260 · S/N 24-4169Built 1965 · Barry Edward P IIIN875TBeech S35 · S/N D-7837Built 1965 · Mw Leasing IncN8826PPiper PA-24-260 · S/N 24-4282Built 1965 · Ingalls Equipment LLCN9066MCessna 182P · S/N 18264663Built 1976 · Harbison Laura LN9134BCessna 172 · S/N 36734Built 1958 · Johnson Andrea JN930SRSocata TBM 700 · S/N 1183Built 2017 · Riverside Broncho LLCN9313JPiper PA-28-180 · S/N 28-3406Built 1966 · Lockhart Michael BN9352JPiper PA-28-180 · S/N 28-3450Built 1966 · Diorio Robert AN9668SChampion 7GCAA · S/N 85Built 1966 · Palmer Kit AN97068Stinson 108 · S/N 108-1068Built 1946 · Britton MartinN97HWMarshall Robert William ACRODUSTER SA750 · S/N 600Built 2022 · Marshall Robert WN9872YChampion 7EC · S/N 764Built 1962 · Spee James CN999HJMooney M20M · S/N 27-0018Built 1989 · Sugiono Yudi S
Back to Redlands, CA