Douglas, WY
Registered aircraft · 48
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 = 'DOUGLAS' 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 = 'DOUGLAS' 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.
N101ZPTitan TITAN TORNADO II · S/N DO96XXXCOHK0221N1063QPiper PA-32R-300 · S/N 32R-7780221N109AMAviat A-1A · S/N 1464N122BRBeech 95 · S/N TD-65N1319ZBeech N35 · S/N D-6757N141WSBeech V35 · S/N D-7995N15999Piper PA-28-235 · S/N 28-7310081N201PWUnderwood Reo L SMITH AVN PA-18 SUPE · S/N 04-091N205KHymas Steve RANS S-7S · S/N 0107453N20876Cessna 172M · S/N 17263863N22FEDehaan Lynn B CHALLENGER II · S/N 1163N235SAAmerican Champion 7GCBC · S/N 1445-2008N24BCN24bc BACKCOUNTRY BOSS · S/N BC40524B002N24TPHughes 269C · S/N 340283N25BCBruce Reed BACKCOUNTRY OUTLAW L · S/N BC11406003N2864WChristen Industries A-1 · S/N 1001N4006CStinson 108-3 · S/N 108-5006N401DCessna A185F · S/N 18503517N402BRReed Bruce F RANS S7S · S/N 0405402N411JCSchweizer 269C · S/N S1201N4398ZPiper PA-18-150 · S/N 18-8731N444WYReed Bruce F OUTLAW · S/N TC-O-0808001N4612UCessna 180F · S/N 18051312N4762HPiper PA-11 · S/N 11-684N47HHBell 206B · S/N 2667N51386Cessna 177RG · S/N 177RG1138N51587Maule M-5-220C · S/N 5006CN52448Cessna 182P · S/N 18262615N5365EBeech K35 · S/N D-5854N5522ECessna 150 · S/N 17022N5950GCessna 182P · S/N 18263310N602DDunn David W RANS S-7S · S/N 0107452N60BRBruce F Reed VANS ACFT INC RV-8 · S/N 82702N6314ECessna 172 · S/N 46414N6503TLancair LC-40-550FG · S/N 40039N700ATEnstrom Helicopter 280C · S/N 1193N70KRRon Apfelbaum SQ2 · S/N TCQ0908060N725ARBeech C90 · S/N LJ-879N759UVCessna 182Q · S/N 18266278N8058WPiper PA-28-180 · S/N 28-2135N8183MCessna T210M · S/N 21062033N8482DCessna A185E · S/N 185-1370N8625MBeech P35 · S/N D-7298N88443Bellanca 8GCBC · S/N 130-75N916WTCessna T206H · S/N T20608752N9189SRans Employee Flying Club RANS S-7 · S/N 0301301N929CEPiper PA-18-150 · S/N 18-5001N9421BBlock Joseph D GLASTAR · S/N 5363
Back to Douglas, WY