Bentonville, AR
Registered aircraft · 126
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 = 'AR' AND g.registrant_city = 'BENTONVILLE' 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 = 'AR' AND g.registrant_city = 'BENTONVILLE' 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.
N1040FCessna A185F · S/N 18502697N105GBGame Composites GB1 GAMEBIRD · S/N 0104N111CCessna A185F · S/N 18502600N1137MCessna 210M · S/N 21061921N113GBGame Composites GB1 GAMEBIRD · S/N 0108N119GBGame Composites GB1 GAMEBIRD · S/N 0109N128SKDassault FALCON 7X · S/N 473N131SDBell OH-58A · S/N 69-16231N132GBGame Aerospace GB2 · S/N 001N134SDBell OH-58A · S/N 70-15410N137ALCessna 172N · S/N 17268125N1380WMooney M20C · S/N 2661N140WWaco Classic YMF-F5C · S/N F5C-8-140N1465TPiper PA-32-260 · S/N 32-7200040N151JTNorth American/Aero Classics P-51D · S/N 44-63577First renewal noticeN1564DBeech A36 · S/N E2905N156SFFieseler Werke FI-156-C7 · S/N 3452N15DPTextron 680 · S/N 680-0577N16CPTextron 680 · S/N 680-0567N171GBGame Composites GB1 GAMEBIRD · S/N 0001N172WNCessna 172N · S/N 17270565N178LABeech F90 · S/N LA-178N1792RCessna A185F · S/N 18502508N17ZPTextron 680 · S/N 680-0566N181WCirrus Design SR22T · S/N 0675N1830FBeech A36 · S/N E-1905N191GBGame Composites GB1 GAMEBIRD · S/N 0121N195JFCessna 195A · S/N 7576N201GBGame Composites GB1 GAMEBIRD · S/N 0110N2025GGame Composites GB1 GAMEBIRD · S/N 0111N2071ABell OH-58A · S/N 72-21359N208KRCessna 208 · S/N 208-00304First renewal noticeN211MFSiai-Marchetti S 211 · S/N 031/02-020N211TBRobinson Helicopter R44 · S/N 2106N2139MPiper J3C-65 · S/N 20926N2278HErcoupe 415-C · S/N 2903N229LJLearjet 31A · S/N 229N2351YCessna 177 · S/N 17700151N2457BTemco GC-1B · S/N 3757N24806Piper J3C-50 · S/N 3459N2605GCessna 182B · S/N 51905N2778FCessna 182J · S/N 18256878N28153Piper J5A · S/N 5-124N287LHRobinson Helicopter R44 · S/N 2787N28GCGame Composites GB1 GAMEBIRD · S/N 0028N29STStemme STEMME S 12 · S/N 12029N2SWAirbus Helicopters AS 350B3 · S/N 8746N3239LCessna 172H · S/N 17256139N328WHCirrus Design SR22T · S/N 0547N350SGAmerican Eurocopter AS350B3 · S/N 7274
Back to Bentonville, AR