OpenAirDocs.org
Buttonwillow, CA

Registered aircraft · 17

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

N1107KLuscombe 8A · S/N 3834Built 1946 · Buttonwillow Land & Cattle CoN119NRHiller UH-12E · S/N 1472Built 1966 · Slikker Flying Service IncN15588Air Tractor AT-502A · S/N 502A-0175Built 1992 · Slikker Flying Service IncN20LDBaker Bobby Dean RV-4 · S/N 002Built 1987 · Slikker Flying Service IncN28908Hiller UH-12E · S/N 1332Built 1962 · Slikker Flying Service IncN302AEDJI AGRAS T50 · S/N 1581F6BUB2449001CD82Slikker Flying Service Inc DBAN4029SHiller UH-12E · S/N 5129Built 1980 · Slikker Flying Service IncN40690Bell UH-1H · S/N 66-00816Built 1966 · Slikker Flying Service IncN514RLBell 206L-3 · S/N 51514Built 1991 · Slikker Flying Service IncN5286Grumman G-164A · S/N 562Built 1968 · Slikker Flying Service IncN6470Hiller UH-12E · S/N 1601Built 1963 · Slikker Flying Service IncN6725KGrumman Acft ENG Cor-Schweizer G-164B · S/N 438BBuilt 1978 · Slikker Flying Service IncN725YGHawker Beechcraft G36 · S/N E-3842Built 2008 · Buttonwillow Land And Cattle CoN802FYAir Tractor AT-802A · S/N 802A-0676Built 2016 · Slikker Flying Service IncN8247KGrumman Acft ENG Cor-Schweizer G-164B · S/N 632-BBuilt 1979 · Slikker Flying Service IncN96071Hiller UH-12E · S/N 1487Built 1964 · Slikker Flying Service IncN99262Hiller UH-12E · S/N 1212Built 1959 · Slikker Flying Service Inc
Back to Buttonwillow, CA