Rio Rancho, NM
Registered aircraft · 119
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 = 'NM' AND g.registrant_city = 'RIO RANCHO' 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 = 'NM' AND g.registrant_city = 'RIO RANCHO' 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.
N105EECameron Balloons US 0-105 · S/N 6792N105WBCameron Balloons US 0-105 · S/N 6677N1061AAdams Balloon A55 · S/N 045N1063VAdams Balloon A55S · S/N 099N128JDDane Julie RV6A · S/N 24632N129WBThunder & Colt Balloons 240A · S/N 2426N1304CCameron Balloons US C-100 · S/N 6414N1465LBeech A23 · S/N M-862N150LBLindstrand Balloons 90A · S/N 5315N1527TFirefly Balloons FIREFLY 8B-15 · S/N F8B-2022N1603UCameron Balloons US C-80 · S/N 5953N1605UCameron Balloons US O-90 · S/N 5958N1624MCameron Balloons US Z-77 · S/N 7029N1884RRaven Industries RX6 · S/N RX6-266N194KLLehmann Kevin S AX8 · S/N 199401KLN1954YMooney M20C · S/N 2691N2003HNational Ballooning 858 · S/N 135N2078GCessna 182A · S/N 51378N2079BCameron Balloons US O-56 · S/N 5421N2083JCameron Balloons Z-90 · S/N 6600N20UMUltramagic N-210 · S/N 210/154N2117PFirefly Balloons FIREFLY 8B-15 · S/N F8B-2092N21510Firefly Balloons FIREFLY 8B-15 · S/N F8B-2080N21801Ultramagic S A Z-90 · S/N 90/191N2185ZGalaxy Balloons GALAXY 9B · S/N GLX-1109BN2215SHead Balloons AX8-88B · S/N 359N233TWKubicek Factory S R O BB34Z · S/N 2102N242MSBalloon Works FIREFLY 7B-15 · S/N F7B-379N242NULuenenborg C A/Kennedy H F AX8 · S/N HAB 7N244TCThunder & Colt Airborne Amer AX8-90 S 2 · S/N 2105USAN2669KLuscombe 8E · S/N 5396N2808CRaven S55A · S/N S55A-1100N2854AAerostar International RX-7 · S/N RX7-3005N30237Cameron Balloons US Z-90 · S/N 6943N3082LHead Balloons AX8-88 · S/N 281N30UMUltramagic S A M-105 · S/N 105/249N311WHWilliam J Hutson STOL CH 750 · S/N 75-8370N315JKKessler James H VANS RV-6 · S/N 22414N31802National Ballooning 858 · S/N 161N3181NNational Ballooning 858 · S/N 164N340EMCessna 340A · S/N 340A1516N34432Cessna 177B · S/N 17701799N368DBDahl-Bredine C/Air Creation TW TWIN · S/N T03106N36UMUltramagic M-130 · S/N 130/115N370WNRicardo De Almeida N-42 · S/N 2010/127N4006GAerostar International RX 8 · S/N RX8-3282N4016JCameron Balloons US RJ-32 · S/N 6431N40190Arbc Inc DBA Lindstrand 90A · S/N 5810N40255Cameron Balloons US Z-77 · S/N 6459N4070KBalloon Works FIREFLY 7 · S/N 10052
Back to Rio Rancho, NM