Redding, CA
Registered aircraft · 193
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 = 'REDDING' 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 = 'REDDING' 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.
N106VECessna 208B · S/N 208B0769N113MXTed E Seeley SUPER CUB · S/N 002N115SFBell Helicopter Textron Canada 407 · S/N 54388N117RCCessna 172RG · S/N 172RG0034N118ACessna A185F · S/N 18503339N121HACessna 208B · S/N 208B0069N128SCCessna 172S · S/N 172S8250N12PUMeyer Dan PITTS-SUPERSTINKER · S/N 008N137LZPZL 101 · S/N 119276N1408BCessna 172S · S/N 172S10429N1527Bensen-Werts B-8M · S/N 1N1550GBeech A36 · S/N E-2484N1570VCessna 172M · S/N 17263671N162MECessna 172S · S/N 172S8442N1697PPiper PA-22 · S/N 22-2483N171RJCessna 150F · S/N 15063038N172KKCessna 172R · S/N 17280574N1818ACessna 182Q · S/N 18266532N1833KLuscombe 8E · S/N 4560N1876VCessna R172K · S/N R1722217N1911VPiper PA-28-180 · S/N 28-7405103N1917XKilpatrick John N SPAD XIII C.1 · S/N 05-01N192TUCostruzioni Aeronautiche Tecna P2006T · S/N 192/USN197KCBruce Swanston BSA GRIZZLY · S/N 00001N19SBCessna T337G · S/N P3370018N205BTBell 205A-1 · S/N 30173N2066ZCessna 150C · S/N 15059866N208HWCessna 208B · S/N 208B0118N208PGCessna 208B · S/N 208B-0799N208TMCessna 208B · S/N 208B0413N2103TCessna 172R · S/N 17281205N2118LCessna 172R · S/N 17280676N212BTBell 212 · S/N 30870N2155MPiper PA-28R-201T · S/N 28R-7803111N224AJCirrus Design SR22T · S/N 10255N230EZMeyer Daniel B MEYERFLYER 230 · S/N 462N2364CCessna 180 · S/N 30664N2369BGlobe GC-1B · S/N 3669N238WMPiper PA-28-235 · S/N 28-10924N2390CCessna 172R · S/N 17280789N23THBeech 35-C33 · S/N CD-1019N2400DCessna 170B · S/N 20552N24612Cessna 172R · S/N 17280827N25511Piper PA-28-140 · S/N 28-25718N2572LCessna A150L · S/N A1500485N257HSVans RV-12 · S/N 120338N2623DCessna 170B · S/N 20775N26630Cessna 172R · S/N 17280565N28932Engineering & Research 415-C · S/N 27N2912TAero Commander 200D · S/N 318
Back to Redding, CA