Chico, CA
Registered aircraft · 158
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 = 'CHICO' 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 = 'CHICO' 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.
N101PABeech A36TC · S/N EA-39N10218Grumman G-164 · S/N 18N10FRReynen Frank R KOLB MARK III · S/N 022N1128YCessna 150B · S/N 15059528N119DHCessna 172 · S/N 36257N121WMBellanca 8KCAB-180 · S/N 638-80N12527Cessna 172M · S/N 17262042N1554XPiper PA-28R-200 · S/N 28R-7535324N1577KLuscombe 8C · S/N 4304N169NCessna 180E · S/N 18051138N16KMRobinson Helicopter R66 · S/N 0962N1786NCessna 120 · S/N 12030N1873LBeech V35B · S/N D-9892N1879CCessna 170B · S/N 26023N1954KLuscombe 8E · S/N 4681N1955EBigbee Mark S QUICKSILVER GT-500 · S/N 166N19669Cessna 172L · S/N 17260652N2027SHead Balloons AX9-118 · S/N 430N202JVVenaleck John T RV-8 · S/N 81140N21365Aeronca 65-C · S/N C-1788N2185XPiper PA-28-181 · S/N 28-7990366N21CTCessna P210N · S/N P21000021N22049Cessna 150H · S/N 15068030N22863Cessna 150H · S/N 15068571N23215Cessna T206H · S/N T20608754N234SJBell UH-1B · S/N 388N236HBrewster FLEET 2 · S/N 104N2423MRichards James W VANS RV9A · S/N 90611N2456EChampion AERONCA 7AC · S/N 6035N245JDRolladen-Schneider LS 4A · S/N 4329N259DCEmbraer Executive EMB-500 · S/N 50000406N25JCCessna 210 · S/N 57008N26122Grumman American Avn. AA-5A · S/N AA5A0443N2619JCessna 150G · S/N 15065619N263DCDiamond Aircraft Ind DA20-C1 · S/N C0503N2656SCessna T210L · S/N 21061346N2662ZCessna 182S · S/N 18280338N2673SCessna T210L · S/N 21061348N2689TCessna 414A · S/N 414A0403N275DMCessna 180J · S/N 18052558N27HSSchooler JUNIOR ACE · S/N HS-1N2885FPiper PA-28-181 · S/N 28-7990521N29264Superior CULVER LCA · S/N 133N2947Piper PA-24-260 · S/N 24-4681N3003BPiper PA-28-181 · S/N 28-7990133N3114XNew Piper PA32-301FT · S/N 3232052N31393Aeronca 65-CA · S/N C10550N3215DBeech A36 · S/N E-2912N321GWCessna 182S · S/N 18280209N327HSHarold Schooler HARMON ROCKET · S/N V4455-HR327-HS3
Back to Chico, CA