Gillette, WY
Registered aircraft · 88
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 = 'GILLETTE' 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 = 'GILLETTE' 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.
N1028MCessna 182P · S/N 18264212N104SEElliott Group RANS S6S - KITPLANE · S/N 05971122N1104ZHughes 269C · S/N 1000973N1204SSix Chuter SR7 XL · S/N 99-2109-SR7XLN1329APiper PA-18 · S/N 18-1140N133DWWalsh Denis L RV-6A · S/N 22012N13XPCummings John/Pamela MCHOLLAND XPA-11 · S/N 2N14WFBellanca 8GCBC · S/N 233-76N151SAAmerican Champion 7GCBC · S/N 1448-2008N1558ZBeech 35-B33 · S/N CD-428N1764CCessna 180 · S/N 30464N180ESCessna 180 · S/N 31047Registration pendingN180GMCessna 180A · S/N 32967N185KTCessna A185F · S/N 18503595N190MADiamond Aircraft Ind DA 40 · S/N 40.355N2156APiper PA-18A-135 · S/N 18-1870N219PSPiper PA-18-135 · S/N 18-4037N2338GCessna 182B · S/N 51638N2372SPiper PA-18-150 · S/N 18-7909138N252SCessna 340A · S/N 340A0984N2717TBeech 95-C55 · S/N TE-351N2848WBeech V35B · S/N D-9492N28MRIwersen Lorenz P ZODIAC 601 XL · S/N 65551Registration pendingN2930BBeech D35 · S/N D-3571N3005ACessna 170B · S/N 25649N307NRCirrus Design SR22T · S/N 10386N315CHAerospatiale SA315B ALOUETTE III · S/N 2456N316DRQuartz Mountain Aerospace 11E · S/N 1014N3387FCessna 182J · S/N 18257387N339MECessna 182S · S/N 18280734N3410CCessna 170B · S/N 26453N3426HErcoupe 415-C · S/N 4051N3530CCessna T206H · S/N T20608287N35488Cessna 172I · S/N 17256797N3762BBuckley Clyde W VARIEZE · S/N 1249N3804PPiper PA-22-150 · S/N 22-3493N3996LSix Chuter SR7X1 · S/N 99-2240-SR7X1N4122WPiper PA-32-300 · S/N 32-40186N41577Piper PA-18-150 · S/N 1809086N4305WBeech E-55 · S/N TE-967N4327JPiper PA-32-301 · S/N 32-8406001N433PCPiper PA-18A 150 · S/N 18-4874N4398APiper PA-18-150 · S/N 18-4813N4422LForster L G/Big Max LG2 · S/N LGF02N467PSMooney M20R · S/N 29-0481N468PACessna T240 · S/N T24002030N4720APiper PA-18-150 · S/N 18-4941N4966ZPiper PA-22-108 · S/N 22-8573N4KXCessna 180K · S/N 18052816N5051LBellanca 8GCBC · S/N 316-79
Back to Gillette, WY