Sandpoint, ID
Registered aircraft · 133
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.
N1085YLithuanian Factory Of LAK-12 · S/N 6224N109WWade Burnett SUPER CUB · S/N SC-18-187N10ZWCirrus Design SR22 · S/N 0055N110WMPreceptor N-3 · S/N 0787PN113FCBeech B23 · S/N M-1229N1157SPiper PA-31-325 · S/N 317812093N115WSSittauer Larry STARDUSTER II SA300 · S/N 2185N12AVBeech F33A · S/N CE-603N1312APiper PA-18-125 · S/N 18-1114N131THSikorsky UH-60L · S/N 97-26746N133THSikorsky UH-60A · S/N 81-23616N1411APiper PA-22 · S/N 22-323N1411BLuscombe 8F · S/N 6038N147BKim S Olson SUPER REBLE · S/N 081 SRN163MAAviat A-1B · S/N 2303N16801Fairchild 24 C8E · S/N 2821N169BWPiper PA-32RT-300 · S/N 32R-7885080N16VPPaepeghem HP-16 · S/N 16-20N177EBCessna 177 · S/N 17700562N1791PPiper PA-22 · S/N 22-2564N180PSMarshall John R S1C JM · S/N 180-1N1848NBeech 77 · S/N WA-312N18ALChivers THORP T-18 · S/N 287N20061Cessna 172M · S/N 17260973N203LALanshe Aerospace LAKE 250 · S/N 237N2044GCessna 182A · S/N 51344N206JJCessna U206C · S/N U206-1012N21REConsolidated Aeronautics LAKE LA-4-200 · S/N 900N2295ZBangle David M MURPHY REBEL · S/N 42N2373DNathan DYK SAVANNAH S · S/N 12-09-54-0208N2384MPiper PA-12 · S/N 12-1510N250DHKodiak KODIAK 100 · S/N 100-0374N254DDSdcc CCX-2000 · S/N CCX-2000-0067N267KAKaman Aerospace K-1200 · S/N A94-0037N286KDKodiak KODIAK 200 · S/N K2-0034N290THSikorsky UH-60A · S/N 79-23290N302DMMcintosh Donald W KITFOX SERIES 7 · S/N S70407064N310FJCessna T310Q · S/N 310Q0542N312TKStemme S10-VT · S/N 11-071N316BRBill Rusk PA-18 REPLICA KIT · S/N JA 1108067N31CYSukhoi SU-31 · S/N 04-04N320DKodiak KODIAK 200 · S/N K2-0032N32734Piper J3C-65 · S/N 5568N32792Piper J5A · S/N 5-386N3410NMooney M20F · S/N 680043N3463FCessna 182J · S/N 18257463N3505LCessna 150F · S/N 15062305N3600DKodiak KODIAK 200 · S/N K2-0036N365DHKodiak KODIAK 100 · S/N 100-0365N367KAKodiak KODIAK 100 · S/N 100-0367
Back to Sandpoint, ID