Lander, WY
Registered aircraft · 55
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 = 'LANDER' 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 = 'LANDER' 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.
N100YVMooney M20J · S/N 243194N118RCMooney M20F · S/N 670036N140WYCessna 140 · S/N 12865N14XPMcholland XPA-11 · S/N 3N150CWPiper PA-18A · S/N 18-4329N172CDCessna 172F · S/N 17252386N1929RReedy Thomas AIR CAMPER · S/N 121N21HVUmeno Hiroo VELOCITY · S/N SUV103N225SSQuicksilver Manufacturing MX SPRINT · S/N 326N249NADJI AGRAS T50 · S/N 1581F6BUB2488001S4M2N251NATalos Drones TALOS T60X · S/N 2104F7EZB251J00192FPN2607DCessna 170B · S/N 20759N2675CDJI INSPIRE 2 · S/N EC131410596209N2781DJI AGRAS T50 · S/N 1581F6BUB234700102EGN307BCAmerican Industrial Laundry BACKCOUNTRY SUPER CR · S/N TCQ1310091N325FCHylio AG-130 · S/N 050205N325TWSocata TBM 700 · S/N 1066N345JTSabre SABRE 503 · S/N C0386GN3741DCessna 182A · S/N 34441N3827HMooney M20J · S/N 24-0953N418MAPiper PA-46-600TP · S/N 4698043N4250Piper PA-24-250 · S/N 24-894N4292Basil E Winch SA11A STITS PLAYBOY · S/N 131N437WYHowell James W RV-4 · S/N 1318N44104Piper PA-28R-200 · S/N 28R-7435295N46UPiper PA-46-310P · S/N 4608072N477LLPiper PA-18-150 · S/N 18-8755N4QLBeech B200 · S/N BB-942N501XXSnyder Robert L QUICKSILVER GT 500 · S/N 0414N5022WPiper PA-28 · S/N 28-23N5127RCessna 172M · S/N 17263344N552XTGteex Revolution INDEPENDENCE 19 · S/N 212985300C70DN64201Cessna 172M · S/N 17265083Registration pendingN6899VMooney M20F · S/N 22-1286N6939VMooney M20F · S/N 22-1312N70VBSmith AEROSTAR 600 · S/N 60-0446-150N7132PPiper PA-24-250 · S/N 24-2297N713MMAviat A-1 · S/N 1275N721TJCirrus Design SR22T · S/N 0681N738ZNCessna 172N · S/N 17270367N74416Grumman American Avn. AA-5B · S/N AA5B-0217N767DGMartin Dennis G VELOCITY 173 FG ELTE · S/N DM0410N76CCCubcrafters CC11-160 · S/N CC11-00216N76HPMooney M20F · S/N 700010N82458Aeronca 7AC · S/N 7AC-1091N82704Aeronca 7AC · S/N 7AC-1352N82870Champion 7AC · S/N 7AC-1520N831ARRupp Scott SONERAI IIL · S/N SAR071106-0825N8453XPiper PA-44-180T · S/N 44-8107066N8609XCessna 180D · S/N 18051009
Back to Lander, WY