Cody, WY
Registered aircraft · 84
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 = 'CODY' 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 = 'CODY' 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.
N1096UCessna 172M · S/N 17266845N1108PCessna T182T · S/N T18208639N113BSCessna 182G · S/N 18255205N12YYJohn Lawrence Brouillette RV-14A · S/N 140550N131TJCirrus Design SR22 · S/N 3449N149EAEclipse EA500 · S/N 000149N1687XCessna T210L · S/N 21060722N170WYCessna 170B · S/N 26592N171KAeropro CZ S R O A240 · S/N 58620N187WFrank C Watson CCX-2300 · S/N CCX-2300-0106N204DKKirkwood Dennis H RV-6A · S/N 60285N2102GCessna 182A · S/N 51402N22116Aeronca 65-C · S/N C2208N22657Taylorcraft BC12D-85 · S/N 1304N231HDDJI AGRAS T40 · S/N 1581F574B235400100C6N231LPMooney M20K · S/N 25-0300N234SRalph A Hudson ZODIAC CH 601 XLB · S/N 7165N26MDCessna 180K · S/N 18053144N274STEnstrom Helicopter 480B · S/N 5107N27EBHutchison Kenneth C LANCAIR LEGACY · S/N L2K 138N2887PPiper PA-18-150 · S/N 18-4485N288KHamelmann Karl D RV-8 · S/N 80240N2999Andersen PITTS S-1S · S/N 0001N307DDavid Nicholson CCK-1865 · S/N CCK-1865-1064N30WYAviat A-1B · S/N 2420N310FFCessna 310D · S/N 39053N31604Piper PA-28R-201T · S/N 28R-7803288N321HMAviat A-1C-180 · S/N 3109N331HTTope/Hawk WAGAERO SPORT TRNR · S/N HT-1N335SBAviat A-1B · S/N 2090N338SBPilatus PC-6/B2-H4 · S/N 953N352TWS C Aerostar S A YAK-52TW · S/N 0312501N36WYCessna A185F · S/N 18503311N3780MPiper PA-12 · S/N 12-2710Registration pendingN3800GGT Aeronautics GT380 · S/N GT380-001N38803Piper J3C-65 · S/N 7280N388LCCessna 182H · S/N 18256441N400WYCubcrafters CC11-160 · S/N CC11-00322N41064Stinson 108-3 · S/N 108-5157N413ZPTriskelion Artsn/Pettinger ZENAIR CH 801 · S/N 8-4705N41450Piper PA-28R-200 · S/N 28R-7435184N4149VCessna 170 · S/N 18481N42407Piper J3C-65 · S/N 14667N427MBMichael W Bond BEARHAWK · S/N 427N43JPParker Jeffrey Carl RV 4 · S/N 956N4593DBeech G35 · S/N D-4763Sale reportedN465TPPiper PA46-500TP · S/N 4697204N4699RPiper PA-28-140 · S/N 28-21463N46ETThomas Egbert 801 STOL · S/N 8-6894N475CDCirrus Design SR22 · S/N 1574
Back to Cody, WY