Alpine, WY
Registered aircraft · 65
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 = 'ALPINE' 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 = 'ALPINE' 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.
N119Joe Cooper CCX-2300 · S/N CCX-2300-0066N1297SCessna 182P · S/N 18264864N133VWCessna 182P · S/N 18263927N1537VDehavilland BEAVER DHC-2 · S/N 494N156AAAviat A-1B · S/N 2390N184LWPiaggio Aero Industries P180 · S/N 1187N209KSCessna P210N · S/N P21000560N213WKSchleicher Alexander ASH 26 E · S/N 26213N224LZCirrus Design SR22 · S/N 2767N22CWCirrus Design SR22T · S/N 0601N230SXLancair LC41-550FG · S/N 41045N236MMeyers Industries 200D · S/N 292N246MECessna T206H · S/N T20608194N252GSCessna 182Q · S/N 18265179N260CPSiai-Marchetti SF.260TP · S/N 008/62-001N275DLCubcrafters CC11-160 · S/N CC11-00106N27WSSanders Wiley C JR SANDERS/NA T2B · S/N 1155235N28036Piper J3C-65 · S/N 4535N29LGPiper PA-18-150 · S/N 184783N2SMLearjet 31A · S/N 040N307APMD Helicopters 369FF · S/N 0323FFN319WBJoseph R Cram SPORTSMAN GS-2 · S/N 7362N339LAero Vodochody L-39 · S/N 530432N35947Cessna U206F · S/N U20602821N383HCRockwell International 690A · S/N 11310N409JDCollins Robert S JUST ACFT HIGHLANDER · S/N JAESC0142N413AMAviat A-1B · S/N 2413N414MHCessna 414A · S/N 414A-0455N417SLLynn Ray KITFOX VIXEN · S/N V9502-0026N421JAAviat A-1C-180 · S/N 3027N42SRProgressive Aerodyne SEAREY LSA · S/N 1082N4402QCessna 172M · S/N 17261697N447EMark Summers LANCAIR LEGACY · S/N L2K-327N447WAAirbus Helicopters AS350B3 · S/N 9447N46273North American T-28C · S/N 146273N47TZCessna 182Q · S/N 18265448N487JHBeech B100 · S/N BE-43N487LPiper PA46-500TP · S/N 4697468N5362ACessna T210N · S/N 21063391N542PGCirrus Design SR22 · S/N 3002N544MDSocata TBM 700 · S/N 1111N581EBeech 58 · S/N TH-423N62EHBell 206B · S/N 4191N66RSRobinson Helicopter R66 · S/N 1539Sale reportedN685TCNorthrop F-5A · S/N 1009N6DBHelio H-295 · S/N 1466N715WTCirrus Design SR22 · S/N 1974N7239LBell TAH-1P · S/N 76-22601N72DHRobinson Helicopter R66 · S/N 1279N72RHRobert Hagedorn CCX-2300 · S/N CCX-2300-0023
Back to Alpine, WY