Registered aircraft · 24

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 = 'ROCK SPRINGS' 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 = 'ROCK SPRINGS'
  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 = 'ROCK SPRINGS'
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.

N11UWBalony Kubicek Spol Sro BB30Z · S/N 757Pivic Bruce W N126GHenry Kappes M26 VICTOR · S/N 26245506Built 2024 · Kappes Henry C N12UWBalony Kubicek Spol Sro BB26Z · S/N 1092Built 2014 · Pivic Bruce N134SMacadams Robert TITAN TORNADO SS · S/N SS07XXXC0HK0520Built 2010 · Jefferies Vincent N2136RCessna 182G · S/N 18255336Built 1964 · Gibbens John L Trustee N228PArmbruster Peter VANS RV-6A · S/N 60299Built 2002 · Murley Timothy F N246AJJensen Alan RV-8 · S/N 82207Built 2013 · Jensen Alan N321TEFound Acft Canada FBA-2C1 · S/N 32Built 2001 · Berg Orvie E Trustee N3724XAero Commander 100-180 · S/N 5030Built 1968 · Jefferies Vincent B N37CMSmith AEROSTAR 601P · S/N 61P-0482-195Magpie Inc N42549Cessna 182L · S/N 18259072Built 1968 · Schutz Christopher J N47361Piper PA-28R-201T · S/N 28R-7703363Built 1977 · Magpie Inc N5641AMaule M-5-210TC · S/N 9005CGrandy Leland P N6748VBeech 58TC · S/N TK-120Built 1980 · Cannon Oil & Gas Well Services Inc N6925RCessna T210H · S/N T210-0325Built 1967 · Delong Mark B N6965FCessna 150F · S/N 15063565Built 1966 · Jefferies Vincent B N699GSBeech A35 · S/N D-1976Built 1949 · Bingham Allan S N791QBeech D55 · S/N TE-724Built 1969 · 791q LLC N7965KBeech S35 · S/N D-7469Built 1964 · Blake Manus N81898Piper PA-28RT-201 · S/N 28R-8018064Built 1980 · Zanetti James D N8933DPiper PA-22-160 · S/N 22-6091Grandy Leland P N9128JPiper PA-28-180 · S/N 28-3178Wyoplane LLC N983JBCessna 340A · S/N 340A0453Built 1978 · Constellation Aviation LLC N998BPZing Aerosports 90AE · S/N ZAE-001Built 2019 · Pivic Bruce W

Back to Rock Springs, WY