Rigby, ID
Registered aircraft · 59
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 = 'RIGBY' 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 = 'RIGBY' 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.
N106LAAir Tractor AT-802A · S/N 802A-0106N1107CPiper PA-22-135 · S/N 22-953Sale reportedN13642Air Tractor AT-502B · S/N 502B-0598N14LPAviat PITTS S-2B · S/N 5217N1661FCessna 172H · S/N 17255056N170ACCessna 182 · S/N 18266551N198LAAir Tractor AT-502 · S/N 502-0198N22WCKarlsen Douglas WC-7 · S/N 001N2401YCessna 172D · S/N 17249701N290DBByers Walter D BYERS VARIEZE · S/N 698N2946XDJI AGRAS T20P · S/N 64UBL7B0020047N2981BBeech D35 · S/N D-3621N30343Piper J4A · S/N 41171N307KKKen Koster ZENITH 750 STOL · S/N 75-8782N314PTStrong Thomas W RV 9A · S/N 90489N324TJRobinson Helicopter R66 · S/N 0480N336WTAmerican Champion 8KCAB · S/N 1210-2023N3432MPiper PA-28-161 · S/N 28-7816343N3509BBeech E35 · S/N D-3726N356BQuest KODIAK 100 · S/N 100-0152N38080Piper J4E · S/N 4-1538N3MLMaule M-4-220C · S/N 2048CN41213Piper J4E · S/N 41636N4186GStinson 108-3 · S/N 108-4824N425ECessna 425 · S/N 425-0096N4265DAir Tractor AT-802A · S/N 802A-0259N427NSAir Tractor AT-802A · S/N 802A-0153N437TAEa Vision EA J100 · S/N 85567N4413NInteravia E-3 · S/N 0303N4427MBoam Larry RANS S-6S · S/N 08031518-SN45823Luscombe 8A · S/N 2350N49LGRobinson Helicopter R66 · S/N 0114N500JAMaule MT-7-260 · S/N 27006CN5109DCessna 182A · S/N 51209N5207BCessna 162 · S/N 16200024N52767Cessna 182P · S/N 18262834N5564RCessna 172F · S/N 17253156N581TWAir Tractor AT-502B · S/N 502B-2581N6060NCessna T206H · S/N T20608658N628CCessna 425 · S/N 425-0041N702ECCirrus Design SR22T · S/N 1301N737TZCessna 172N · S/N 17269674N73DWCessna 425 · S/N 425-0089N7503BChampion 7FC · S/N 7FC-11Sale reportedN80287SLY Russell M RV-6A · S/N 22902N80293Air Tractor AT-802A · S/N 802A-0720N802TPAir Tractor AT-802 · S/N 802-0665N8047FCessna 150F · S/N 15064147N81090Duncan Stanley W PRECEPTOR ULTRA PUP · S/N D04-101N838ACEmigh TROJAN A-2 · S/N 56
Back to Rigby, ID