Registered aircraft · 23

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 = 'WY' AND g.registrant_city = 'WILSON' 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 = 'WY' AND g.registrant_city = 'WILSON'
  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 = 'WILSON'
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.

N112DNaval Aircraft Factory N3N-3 · S/N 2659Built 1941 · Sugden Richard G N142MCBeech 95-B55 · S/N TC-1579Built 1973 · Cassen Mark E N147RSBell 47G-3B-2 · S/N 2636Sugden Richard G N18049Dehavilland DHC-1B-2-S5 · S/N 187/225Built 1956 · Laumeyer Richard H N18NXEdwin H Cooper JR CCX-2300 · S/N CCX-2300-0024Built 2021 · Tennican Geoffrey N199XExtra Flugzeugbau EA 300/L · S/N 138Built 2001 · Sugden Richard G N212TBRockwell / Prineas ROCKWELL T-2B · S/N 155226Built 1968 · Sugden Richard G N234LTMcdonnell Douglas TA-4J · S/N 158141Built 1972 · Sugden Richard N2FCChristen Industries CHRISTEN EAGLE II · S/N 0001Built 1977 · Christensen Frank L Trustee N339RSAero Vodochody L39C · S/N 931338Built 1979 · Sugden Rich N439RSAero Vodochody L39C · S/N 131907Built 1981 · Sugden Richard N468RSSugden Richard MINI 500 · S/N 468Sugden Richard G N5937GCessna 150K · S/N 15071437Built 1969 · D'Arge Ranyon Wc N66DFCessna T210M · S/N 210-621-41Built 1977 · Clark Samuel D Trustee N726RSQuest KODIAK 100 · S/N 100-0043Built 2010 · Sugden Richard N72KDCirrus Design SR22T · S/N 8896Built 2022 · N72kd LLC N7668TCessna 172A · S/N 47268Built 1960 · Hoff Stephen R N81229Fairchild 24W-46 · S/N W46130Built 1946 · Cassen Mark E N8379QCessna A185F · S/N 18503673Built 1978 · Laumeyer Richard H N88JHBeech B200 · S/N BB-1331Built 1989 · Teton Aviation Limited Liability Company N914SAFoxair KITFOX LIGHT SPORT · S/N KA11219208Built 2012 · Smith Air LLC N934RSBeech T-34B · S/N BG-77Built 1955 · Sugden Richard G N97BHCessna 560 · S/N 560-0290Ts72 Management LLC

Back to Wilson, WY