Driggs, ID
Registered aircraft · 38
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 = 'ID' AND g.registrant_city = 'DRIGGS' 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 = 'ID' AND g.registrant_city = 'DRIGGS' 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.
N1085SMooney M20M · S/N 27-0036N111JYRasmussen Kelly D KITFOX S7 STI · S/N KA22264558N1410CLindstrand Balloons 105A · S/N 5345N15XPMcholland C L SOLITAIRE · S/N 30N169JMCessna P210N · S/N P21000169N184CMMoen Craig N RV-8 · S/N 80338N2224JCessna 150G · S/N 15065424N3074QCessna 182K · S/N 18258074N3080KBeech A36 · S/N E-2389N310VZBombardier BD-100-1A10 · S/N 20366N332SHRed Tail Bay CCX-2000 · S/N CCX-2000-0154N399DSDiamond Aircraft Ind DA 40 · S/N 40.900N39HUAviat A-1C-200 · S/N 3234N410EAPipistrel D O O ALPHA TRAINER · S/N AT162A0016N418EAPipistrel D O O ALPHA TRAINER · S/N AT162A0021N4828DCessna 182A · S/N 34928N49629Cole Timothy WW-7C · S/N 1984-1N50089Head Balloons AX8-105 · S/N 489N5175LCirrus Design SR22 · S/N 1542N5446Dehavilland TIGER MOTH DH 82A · S/N A17-392N5519YMaule MT-7-235 · S/N 18055CN555VALancair LC41-550FG · S/N 41033N585BBCessna 182P · S/N 18262136N691AMRasmussen Kelly D RV7 · S/N 74981N7132BPiper PA-22-150 · S/N 22-4351N770CBCessna R172K · S/N R172-2175N77WYAviat A-1B · S/N 2419N80009Avian Balloon MAGNUM IX · S/N 213N82CQDehavilland DH 82-C · S/N 327N834DCCessna S550 · S/N S5500035N8638UCessna 172F · S/N 17252540N881DStinson 108-2 · S/N 108-2881N889DSDiamond Aircraft Ind DA 40 · S/N 40.889N889GSAmerican Champion 8KCAB · S/N 853-99N906PADiamond Aircraft Ind DA 40 · S/N 40.906N911THHughes 269A · S/N 291093N9190UPowrachute AIRWOLF · S/N A 006 ULSN99EDFlight Design CTSW · S/N 06-04-11
Back to Driggs, ID