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.
N7330MCessna 175 · S/N 55630N7348RBeech 95-B55 (T42A) · S/N TC-1709N735NSCessna 182Q · S/N 18265560N73QDehavilland BEAVER DHC-2 MK.1 · S/N 302N7434RPiper PA-28-140 · S/N 28-21969N7521KCessna 180J · S/N 18052660N759BECessna 182Q · S/N 18265856First renewal noticeN78654Piper PA-11 · S/N 11-454N7878CTaylorcraft DC-65 · S/N 6245N791TBBidus Brent E KITFOX CLASSIC 4 · S/N C9802-0218N800DEDG Flugzeugbau DG-800B · S/N 8-147B71N8192BCessna 172 · S/N 29992N829WDKodiak KODIAK 100 · S/N 100-0375N8401XCessna 172C · S/N 17248901N842THSikorsky UH-60L · S/N 84-23970N8476JPiper PA-14 · S/N 14-204N8537EChampion 7EC · S/N 7FC-343N881VCCirrus Design SF50 · S/N 0238N8847JPiper PA-28-180 · S/N 28-2805N893KAircraft Builders STUDENT PRINCE X · S/N 102N895DSSwenson Donald R RV-6A · S/N 20530N8989XDevin Sirois SUPER CUB EXP · S/N 001N900KXKodiak KODIAK 200 · S/N 200-0001N902ARKodiak KODIAK 200 · S/N K2-0035N916THSikorsky UH-60A · S/N 83-23916N942VTLenart David R AVIPRO BEARHAWK · S/N 942N9438NCessna A185F · S/N 18504356N953CNCraig Ellison BEARHAWK FOUR · S/N 443-87/88N953TWEllison Craig M GLASAIR SPORTSMAN · S/N 001N955DWCub Crafters PA18-150 · S/N 9969CCN9598ZChristen Industries A-1 · S/N 1102N962SPKodiak KODIAK 100 · S/N 100-0372N9894GCessna 172L · S/N 17259794N9950DPiper PA-22-150 · S/N 22-6738
Back to Sandpoint, ID