OpenAirDocs.org
Fruita, CO

Registered aircraft · 30

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 = 'CO' AND g.registrant_city = 'FRUITA'
  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.

N120YCessna 120 · S/N 9514Built 1946 · Baldwin James CN128GPParkerson Gary QUICKSILVER SPORT II · S/N 128Built 1990 · Parkerson Gary LN132AXBalloon Works-Mills AX-7 · S/N F7-020Built 1983 · Grand Junction Balloon PortN1750TPiper PA-28-140 · S/N 28-7125068Built 1970 · Van Strand Investments LLCN2012YCessna 182T · S/N 18281770Built 2006 · Lake Robert PN2057FBalloon Works FIREFLY 8B-15 · S/N F8B-604Built 2000 · Grand Junction Balloon PortN217DRPiper J3C-65 · S/N 6415Built 1941 · Tec Concepts LLCN24950Cessna 152 · S/N 15280467Built 1977 · Erbisch RobertN3183WWood Clarence E ZENAIR CH-701 · S/N 7-1702Wood Blaine AN3466JCessna 150G · S/N 15066166Sale reportedBuilt 1967N3724KPiper PA-28-140 · S/N 28-23703Built 1967 · Treharne Russell CN403SXCook Kenneth J SONEX · S/N 0403Built 2004 · Allen Timothy TaylorN42265Piper J3C-65 · S/N 14515Built 1945 · Clements Shirley RN4459HMooney M20J · S/N 24-0740Built 1978 · Clements Edward LN45HSKyle B Stone GLASAIR SPORTSMANGS2 · S/N 7220Built 2022 · Stone Kyle BN50TSPiccard AX-6 · S/N 650Built 1973 · Clements Shirley RN616TBBryan Tim G RV-6 · S/N 20983Built 2006 · Christofferson Kevin JN6623FFriedman Jerrold A SONEX · S/N 0964Friedman Jerrold AN6704GCessna 150L · S/N 15072204Ryan Conner JN67ASExtra Flugzeugbau EA 300/L · S/N 163Built 2002 · Aviation Safety LLCN701ZDJohnson Royce J ZENITH 701 · S/N RJ5788-6608Davison Rex DN750DPPiermattei Donald L ZENITH CH 750 · S/N 7588Built 2010 · Friedman Jerrold AN768FSCirrus Design SR22T · S/N 1738Registration pendingBuilt 2018N801CWWood Clarence E STOL CH801 · S/N 8-4818Built 2007 · Wood Clarence EN8053RHarvey Patten RANS S-6ES · S/N 08061764Built 2007 · Richards Kenneth DN82502Piper PA-18-150 · S/N 18-7709169Built 1977 · Christofferson KevinN850YPPowrachute AIRWOLF 912ULS · S/N A309VIKBuilt 2018 · Bergman Steven CN9127TBeech B23 · S/N M-1148Simon William CoreyN9310GCessna 182P · S/N 18260850Built 1971 · Baldwin James CN9343MMooney M20E · S/N 1275Built 1966 · Stateline Trucking Inc
Back to Fruita, CO