Registered aircraft · 18

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'PALISADE' ORDER BY g.n_number

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

N18769Beech C24R · S/N MC-500Built 1977 · Shiel Penny S N2580FBalloon Works FIREFLY 8B-15 · S/N F8B-443Built 1993 · Mullin James G N2630TSix Chuter SR7 XL · S/N 97-1656-2SR7Built 1997 · Pittman Stuart P N2882YCessna 182E · S/N 18253882Built 1962 · Vx Aviation LLC N288TFTalbott Charles W BOREDOM FIGHTER · S/N 370Built 1988 · Talbott Charles W N31GBBettis Gary W BETTIS 1 · S/N 0844-1Miller Bryan N333EMMiller Marquis RV-6A · S/N 60165Talbott Charles W N390RTCubcrafters CC11-160 · S/N CC11-00390Built 2015 · Cornum Kory N4410UDwyer Eldon SIDEWINDER · S/N 212004Lance Gary N4976NCessna 182Q · S/N 18267497Built 1979 · Merlin Aviation LLC N51431New Kolb FIRE STAR II · S/N 1117Built 2001 · Pittman Stuart P N5244JGalaxy Balloons GALAXY 7 · S/N GLX-1557High-Country Aviation Workshop For Kids N5935CDJI AGRAS T100 · S/N 1581F8ZLC25AU0020D2GCunningham Trent L N6030MStinson 108-3 · S/N 108-4030Built 1947 · Pittman Stuart P N79LJBoothby Lon V6 STOL · S/N 001Built 2002 · Bell Russell E N80423Beech 35 · S/N D-23N80423 LLC N8714TCessna 182C · S/N 52614Built 1960 · Pittman Stuart P N995MTHutchison Richard A SKYSTAR VIXEN · S/N V94100019Built 2024 · Talbott Donovan

Back to Palisade, CO