OpenAirDocs.org
Biggs, CA

Registered aircraft · 52

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

N1195VBeech D17S · S/N 6749Registration pendingBuilt 1947N1707GDJI T50 · S/N 7TNBMH10030ESMCalifornia Cooperative Rice Research FoundationN192BPRichards Heavylift Helo UH-1H · S/N 65-10133Built 1965 · Jones Flying ServiceN194BPArrow Falcon Exporters UH-1H · S/N 67-17420Built 1967 · Jones Aviation IncN204GPBell-Colonial UH-1B · S/N 64-14073Built 1964 · Jones Aviation IncN204HTHawkins & Powers UH-1B · S/N 62-2078Built 1962 · Jones Flying ServiceN204PJGarlick Helicopters UH-1B · S/N 621893Built 1962 · Jones Flying Service IncN2671RCessna 182K · S/N 18258371Built 1967 · Cw Equipment Rentals IncN2985YCessna 182E · S/N 18253985Built 1962 · Jones Aviation IncN3299KAyres S2R-T45 · S/N T45-012Built 1996 · Jones Aviation IncN3633CSchweizer G-164B · S/N 776BCw Equipment Rentals IncN40261Ayres S2R-G10 · S/N G10-158Built 1999 · Jones Aviation IncN424NABell UH-1B · S/N 6414021Jones Flying Service IncN444SJBell UH-1B · S/N 391Built 1962 · Jones Flying ServiceN447ATAyres S2R-G6 · S/N G6-103Built 1992 · Jones Aviation IncN4630Grumman Acft ENG Cor-Schweizer G-164A · S/N 1176Built 1973 · Jones Aviation IncN48452Grumman Acft ENG Cor-Schweizer G-164B · S/N 24BBuilt 1976 · Jones Aviation IncN48484Grumman Acft ENG Cor-Schweizer G-164B · S/N 43BJones Aviation IncN5021XRockwell International S-2R · S/N 5053RBuilt 1975 · Jones Aviation IncN531MCGrumman Acft ENG Cor-Schweizer G-164C · S/N 7CBuilt 1978 · Jones Aviation IncN5335Grumman G-164A · S/N 603Built 1969 · Williams Ag ServiceN5368Grumman G-164A · S/N 648Built 1969 · Cw Equipment Rentals IncN6104UCessna T210R · S/N 21064901Lavy Brothers FarmingN6180ABell UH-1B · S/N 62-1994Built 1962 · Jones Aviation IncN6524KGrumman Acft ENG Cor-Schweizer G-164B · S/N 352BBuilt 1977 · Jones Aviation IncN6535KGrumman Acft ENG Cor-Schweizer G-164C · S/N 3CBuilt 1977 · Jones Aviation IncN6555KGrumman Acft ENG Cor-Schweizer G-164C · S/N 4CBuilt 1978 · Jones Flying ServiceN6569KGrumman Acft ENG Cor-Schweizer G-164C · S/N 5CBuilt 1978 · Jones AviationN6587FCessna 150F · S/N 15063187Built 1966 · Jones Aviation IncN6596KGrumman Acft ENG Cor-Schweizer G-164C · S/N 6CBuilt 1978 · Jones Aviation IncN6648QGrumman Acft ENG Cor-Schweizer G-164B · S/N 175BCw Equipment Rentals IncN6693KGrumman Acft ENG Cor-Schweizer G-164C · S/N 22 CBuilt 1978 · Jones AviationN6793KGrumman Acft ENG Cor-Schweizer G-164B · S/N 487BSale reportedBuilt 1978N6971LCessna 310K · S/N 310K0071Built 1966 · Cw Equipment Rentals IncN7502BSchweizer G-164B · S/N 816BCw Equipment Rentals IncN7503LSchweizer G-164B · S/N 826BCw Equipment Rentals IncN7763QCessna 310Q · S/N 310Q0263Built 1971 · Jones Aviation IncN8178GSchweizer G164B-34T · S/N 796BBuilt 1988 · Cw Equipment Rentals IncN817APiper PA-22 · S/N 22-121Anderson Jennifer MN8214SSchweizer G-164B · S/N 787BBuilt 1986 · Cw Equipment Rentals IncN83110Schweizer G-164D · S/N 11DJones Aviation IncN8326KGrumman Acft ENG Cor-Schweizer G-164B · S/N 656BBuilt 1980 · Cw Equipment Rentals IncN8388Grumman Acft ENG Cor-Schweizer G-164A · S/N 880Built 1972 · Williams Clarence EN8424VRockwell International S-2R · S/N 2184RBuilt 1976 · Jones Aviation IncN850MBell UH-1H · S/N 66-16875Built 1966 · Jones AviationN8521VAir Tractor AT-602 · S/N 602-0690Built 2004 · Jones Flying ServiceN854MBell UH-1H · S/N 66-01062Jones Aviation IncN8929QRockwell International S-2R · S/N 2354RBuilt 1977 · Jones Aviation IncN897XGrumman G-164A · S/N 419Built 1966 · Cw Equipment Rentals IncN911BVBell UH-1H · S/N 65-09785Built 1966 · Jones Aviation Inc
Back to Biggs, CA