Laramie, WY
Registered aircraft · 48
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 = 'LARAMIE' 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 = 'LARAMIE' 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.
N100NHPipistrel Lsa SINUS · S/N 618 SF 912 LSAN12TQAviat A-1 · S/N 1270N179MDBeech C90A · S/N LJ-1091N182JVCessna 182C · S/N 52886N200UWBeech B200 · S/N BB-1155N232AKSchweizer SGS 2-32 · S/N 12N24660Beech B19 · S/N MB-565N255PHBell 47J-2A · S/N 3307N256LKHylio AG 230 · S/N 17906100307N294RLAviat A-1B · S/N 2323N2UWBeechcraft B300 · S/N FL-862N3043SCessna 140 · S/N 12709N307UWVision Aerial VECTOR HEXACOPTER · S/N 20135N308MDBeech C90A · S/N LJ1246N31TJJackson Terry C VANS ACFT RV-6 · S/N 60414N3380YCessna 182E · S/N 18254380N33VZVelocity VELOCITY 173 RG ELIT · S/N DMO 320N38178Piper PA-28-181 · S/N 28-7790527N3906YCessna 210D · S/N 21058406N414BHHooker William M LANCAIR IV-P · S/N LIV-211N4236VCessna 170 · S/N 18592N4335ZPiper PA-18-150 · S/N 18-8653N50AFMitsubishi MU-2B-25 · S/N 286N520ABellanca 14-19 · S/N 2073N5246WPiper PA-28-150 · S/N 28-288N555HRMooney M20M · S/N 27-0333N567MDBeech C90A · S/N LJ-1231First renewal noticeN582SSDJI AGRAS T100 · S/N 1581F8ZLC25AH002K099N613BXBoese Steven W RV-6A · S/N 25158N6396FCessna 337A · S/N 337-0396N6830VWinkler James D RV8 · S/N 82340N7081JBellanca 7GCBC · S/N 665-74N71941Luscombe 8A · S/N 3368N725ZNCessna 172N · S/N 17272734N726JCAllen Cameron K RANS 6-XL COYOTE II · S/N 11981280N75342North American AT-6D · S/N 42-44641N7684CPiper PA-34-200T · S/N 34-7570260N7978VCessna 180H · S/N 18051878N810PVCirrus Design SR22T · S/N 1596N8110PPiper PA-24-250 · S/N 24-3360N8265HPiper PA-28-181 · S/N 28-8190039N82779Piper PA-28-181 · S/N 28-8190058N8282VPiper PA-28-161 · S/N 28-8116060N86TWSocata TB 30 EPSILON · S/N 100N934NLDJI MINI 2 · S/N 3Q43JB200SY297N934PDDJI MATRICE 300 RTK · S/N 1ZNBJ9C00C000EN946CCBrown C C VANS ACFT RV6A · S/N RV6A22289N97301Stinson 108 · S/N 108-301
Back to Laramie, WY