Cheyenne, WY
Registered aircraft · 327
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 = 'WY' AND g.registrant_city = 'CHEYENNE' 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 = 'WY' AND g.registrant_city = 'CHEYENNE' 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.
N183NMCessna 182P · S/N 18263646N184RDCessna 182S · S/N 18280466N188VCamair 480 · S/N 101N18FXJim R Richmond CCX-1865 · S/N CCX-1865-0001N191DKMonterosso Richard S SH-2-TD · S/N S/H 191N191GSBreda Nardi Hughes NH500MC · S/N 39N1948Dickerson Jack CHALLANGER TWO · S/N CH20894N197JAgusta A109E · S/N 11616N198PRWaltermire Jeffrey D FIRESTAR II · S/N FS-14-4-00096N19AHAirbus Helicopters MBB-BK117 D-3 · S/N 21297N2003YAir Tractor AT-802A · S/N 802A-0428N200MCCessna 414 · S/N 414-0424N2049QCessna 177RG · S/N 177RG0449N204CACessna 501 · S/N 501-0283N205TABell 205A-1 · S/N 30168N218PJBritish Aerospace BAE 125 SERIES 800A · S/N NA0426N218WCessna 182G · S/N 18255649N21AHHarris Paul Andrew RV-4 · S/N 1961N21HRIsrael Aircraft Industries 1124A · S/N 335Registration ineffective or invalidN21JWEngineering & Research ERCOUPE 415-D · S/N 2358N222BEEclipse EA500 · S/N 000186N222TYAeropilot S R O L 600 · S/N 24124N2240FCessna 310L · S/N 310L0040N224RGHawker Beechcraft G36 · S/N E-3894N227EGEric G Liddell RANS S-21 OUTBOUND · S/N 07240391N227ELRans S-7LS · S/N 0209524N229MMPiper PA46R-350T · S/N 4692029N233HCBell 206B · S/N 4533N234LRGulfstream American G-1159A · S/N 300N2363RCessna 182G · S/N 18255463N2381FCessna 210E · S/N 21058581N2444BTemco GC-1B · S/N 3744N244MJWSK Pzl-Mielec AN-2 · S/N 1G17244N24KWMooney M20M · S/N 27-0330N250RGGulfstream Aerospace G-IV · S/N 1003N2526BLancair LC41-550FG · S/N 41105N252UAviat A-1B · S/N 2143N260GDLearjet 60 · S/N 220N261SECessna 172D · S/N 17249852N2628DCessna 170B · S/N 20780N262GRFrench Edwin L RV-6A · S/N 21387N262WDMooney M20K · S/N 25-0580N2696ZBellanca 7ECA · S/N 1230-78N2773FCessna 182J · S/N 18256873N28347Grumman American Avn. AA-5B · S/N AA5B0576N2838QCessna 172L · S/N 17259838N288RBBurton Ray Arthur CHRISTAVIA MK I · S/N 288N28JMCessna P210N · S/N P21000431N2989VBeech 35 · S/N D-386N29WGBecker Charles Joseph JR SEAREY · S/N 1MK296C
Back to Cheyenne, WY