Redding, CA
Registered aircraft · 193
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 = '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.
N8118SPiper PA-28-236 · S/N 28-8011031N814HACessna 172R · S/N 17280814N817HACessna 172R · S/N 17280828N819FGRaytheon 400A · S/N RK-234N81JGGreaves John P JR VARIEZE · S/N 1478N81KWPitts Special S1C · S/N JM-4-24-38-1N81PNCessna 441 · S/N 441-0037N81RYCessna 340A · S/N 340A1238N82ASSteinbach ART SUNSEEKER · S/N 0001N8330PMcdonnell Douglas Helicopter 369E · S/N 0330EN8436KStinson 108-1 · S/N 108-1436N8466FPiper PA-28-161 · S/N 28-7716006N8466TCessna 182C · S/N 52366N8508BCessna 172 · S/N 36208N8556PPiper PA-24-260 · S/N 24-4013N86920Bellanca 14-13 · S/N 1282N8731EPiper PA-28-151 · S/N 28-7615154N8897TCessna 182C · S/N 52797N8909WMark Allen AVID MARK 4 · S/N MK-26N898DBBrand Donald A VANS RV-8 · S/N 80448N9033ACessna 170A · S/N 18788N9034JPiper PA-28-180 · S/N 28-3063N9051BAeronca 7EC · S/N 7FC-139N90GLCessna 208B · S/N 208B0229N91049Martin Edward I MARTIN L-7 · S/N 001N911SFRaytheon B200 · S/N BB-1659N9120JPiper PA-28-180 · S/N 28-3167N918JRead David T JABIRU J230 · S/N 619N92069Cessna 182M · S/N 18260032Registration pendingN920KBSchleicher ASW-27 · S/N 27123N929KDavid Tucker Read KITFOX S7 SUPER SPRT · S/N KA19117404N932CCessna 208B · S/N 208B0032N93420Ercoupe 415-C · S/N 743N937TETiger AG-5B · S/N 10216N94868Engineering & Research ERCOUPE 415-E · S/N 4992N9577WCessna 172R · S/N 17280527N961BHBell Helicopter Textron Canada 429 · S/N 57146N9623BCessna 208B · S/N 208B0138N9766BCessna 208B · S/N 208B0112N979TMHawker Beechcraft 4000 · S/N RC-28N98LAPiper PA-32R-301T · S/N 3257031N98MGGonzalez Mario G AVID MK4 · S/N 678N9YARoyse Ralph L GLASAIR · S/N 582R
Back to Redding, CA