Sandpoint, ID
Registered aircraft · 134
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 = 'SANDPOINT' 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 = 'SANDPOINT' 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.
N365DHKodiak KODIAK 100 · S/N 100-0365N367KAKodiak KODIAK 100 · S/N 100-0367N3688CCessna 180 · S/N 31187N3691DKodiak KODIAK 100 · S/N 100-0369N3840GLittle Keene H CHALLENGER II · S/N CH2-1005-2691N3923VCessna 170 · S/N 18233N39725Waco UPF-7 · S/N 5858N4075APiper L-18C · S/N 18-2119N41AEPiper PA-24-250 · S/N 24-637N423TFound Acft Canada FBA-2C1 · S/N 43N4321WCub Crafters CC19-215 · S/N CC19-0066N434THTimberline Helicopters UH-60A · S/N 80-23434N437THSikorsky UH-60L · S/N 85-24437N4441CSmith C/Laycock G CHINOOK PLUS 2 · S/N 02124N45924Luscombe 8A · S/N 2451N46721Cessna 172K · S/N 17257452N4712NCessna T182 · S/N 18267302N476FLPiper PA-28-140 · S/N 28-7125281N490KQQuest QUEST KODIAK 100 · S/N K0101N491KCSikorsky UH-60L · S/N 88-26026N492KCSikorsky UH-60L · S/N 84-23983N4946ECessna A185F · S/N 18503916First renewal noticeN49TVBell 206B · S/N 3074First renewal noticeN5046Orchard Richard PATROL BEARHAWK · S/N P49-107P/108PN5046RCessna A185F · S/N 18502988N504KQQuest KODIAK 100 · S/N 100-0028N510PWDehavilland DHC-2 · S/N 641N511GLGreat Lakes 2T-1A-1 · S/N 0511N5187BFarmin Ted C/N ID HS Aerospace VANS ACFT INC RV-12 · S/N 120293N52096Cessna 180J · S/N 18052497N5253NCessna 182Q · S/N 18267602N563DJSikorsky UH-60A · S/N 81-23563N569THSikorsky UH-60A · S/N 81-23569N58TDBeech 58P · S/N TJ-411N6126TSchweizer 269C · S/N S1496N618MFleet 2 · S/N 194N620TJTimberline Helicopters UH-60A · S/N 81-23620N6229ECessna 182R · S/N 18268353N622MRAmerican Legend AL11C-100 · S/N AL-1016N65006Cessna 182A · S/N 34597N6507UMooney M20C · S/N 2261N6557QAlon A2 · S/N A-57N674THKaman Aerospace K-1200 · S/N A94-0035N675THKaman Aerospace K-1200 · S/N A94-0025N6928XCessna 172B · S/N 17247828N704DDSdcc CCX-1865 · S/N CCX-1865-2020N705THSikorsky UH-60A · S/N 82-23705N70DAero Commander 560-A · S/N 268N713THSikorsky UH-60A · S/N 82-23713N7306TCessna 172A · S/N 46906
Back to Sandpoint, ID