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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N504EFMcdonnell Douglas Helicopter 369E · S/N 0500EN50BSGlobe GC-1B · S/N 1118N534CPCirrus Design SR22 · S/N 3035N5387CCessna 140A · S/N 15520N542TBeech N35 · S/N D-6718N55386Socata TB 9 TAMPICO · S/N 1189N5603JCessna 182P · S/N 18263460N568RVNeumayer Ba/Cheesman WC RV-8 · S/N 81000N5716DPiper PA-22-150 · S/N 22-4412N5735QMooney M20E · S/N 726N5832LAmerican AA-5 · S/N AA5-0232N5879CBeech C35 · S/N D-2835N5943TCessna 150D · S/N 15060643N603XDDJI PHANTOM 3 STANDARD · S/N P5ADCG230600GFN6114SCessna TR182 · S/N R18201616N6133CBell 206L-3 · S/N 51544N62PECessna 510 · S/N 510-0363N664RVJohn T Williams RV-10 · S/N 41359N66517Cessna 150M · S/N 15076095N6975CNorth American AT-6G · S/N 51677Sale reportedN7197ZRobinson Helicopter R22 BETA · S/N 3249Non-citizen corporation, flight hours not reportedN7235WPiper PA-28-180 · S/N 28-1054N737GPCessna 172N · S/N 17269409N74505Mooney M20B · S/N 1816Registration pendingN7769Root Erwin L SA300 STRDSTR TOO · S/N SN001LRN777CWPiper PA-28-181 · S/N 28-7890233N80300Cessna 172M · S/N 17266506N81724Aeronca 7AC · S/N 7AC-343N8233DBeech J35 · S/N D-5335N828WTRaytheon A36 · S/N E-3581N8525YHughes OH-6A · S/N 67-16493N8571MBeech 35-B33 · S/N CD-645N861LBLindstrand Balloons 35A · S/N 5430N8628BCessna 172 · S/N 36328N8632ZCessna TP206C · S/N P206-0432N8720PPiper PA-24-260 · S/N 24-4169N875TBeech S35 · S/N D-7837N8826PPiper PA-24-260 · S/N 24-4282N9066MCessna 182P · S/N 18264663N9134BCessna 172 · S/N 36734N930SRSocata TBM 700 · S/N 1183N9313JPiper PA-28-180 · S/N 28-3406N9352JPiper PA-28-180 · S/N 28-3450N9668SChampion 7GCAA · S/N 85N97068Stinson 108 · S/N 108-1068N97HWMarshall Robert William ACRODUSTER SA750 · S/N 600N9872YChampion 7EC · S/N 764N999HJMooney M20M · S/N 27-0018
Back to Redlands, CA