OpenAirDocs.org
Colusa, CA

Registered aircraft · 32

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 = 'COLUSA'
  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.

N10211Grumman G-164 · S/N 11Built 1959 · Valley Air Service LtdN1367WMooney M20C · S/N 2648Built 1963 · Selover Richard DN22580Cessna A185F · S/N 18503076Built 1976 · Carter Benjamin FN22753Bell UH-1B · S/N 64-13985Built 1964 · Martins Dusters IncN24934Piper J3C-65 · S/N 3547Built 1939 · Carter Benjamin FN2768GCessna 182B · S/N 52068Built 1959 · Carrion John HN27FUGarlick Helicopters UH-1H · S/N 63-08821Built 1963 · Martins Dusters IncN2850MPiper PA-12 · S/N 12-1190Built 1946 · Harvey Timothy AN3228XBeech A36 · S/N E-2978Built 1995 · N3228x LLCN344CBMaule MX-7-235 · S/N 10017CKinkle Douglas Charles TrusteeN42053Cessna 182L · S/N 18258832Built 1968 · Jewett Clinton Baxter TrusteeN4295CNanchang China CJ-6A · S/N 2532061Built 1968 · Muir Gene AN4351CChampion 7EC · S/N 7EC-370Built 1955 · Kinkle Douglas C TrusteeN45186Naval Aircraft Factory N3N-3 · S/N 4442Built 1941 · Andreotti Michael DN5014BBeech F35 · S/N D-4276Built 1955 · Macpherson Sherman DN5073XBell UH-1B · S/N 63-8622Built 1963 · Martins Dusters IncN540HPrewitt Thomas R PREWITT FI · S/N 47W Yerxa LLCN6696KGrumman Acft ENG Cor-Schweizer G-164B · S/N 426BBuilt 1978 · Valley Air Service LtdN66MKTaylor Michael A RV-8A · S/N 80987Built 2009 · Taylor Michael AN68467Boeing A75N1(PT17) · S/N 75-4737Built 1950 · Keeley Ralph L IIIN7397RBeech V35B · S/N D-9654Built 1974 · West Michael PN756BYCessna U206G · S/N U20603971W Yerxa LLCN78185Cessna A185F · S/N 18503544Sankey Paul FN821HCCessna T206H · S/N T20608846Built 2008 · Axel Farms LLCN8289KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 648BBuilt 1980 · Valley Air Service LimitedN83360Aeronca 7AC · S/N 7AC-2027Built 1946 · Sankey Paul FN84714Aeronca 7AC · S/N 7AC-3427Built 1946 · Macpherson Sherman DN849WYRobinson Helicopter R44 · S/N 2253Built 2012 · Yerxa W A DBAN84WTPiper PA32-301XTC · S/N 3255021Built 2004 · Andreotti Mark CN85609Aeronca 7AC · S/N 7AC-4352Built 1946 · Neader Steven WN9003Lancair LC41-550FG · S/N 41074Built 2005 · Andreotti MarkN9RLCessna 182H · S/N 18255986Built 1964 · Krug Heath
Back to Colusa, CA