Sherwood, AR
Registered aircraft · 32
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 = 'SHERWOOD' 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 = 'SHERWOOD' 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.
N103BSPiper PA-12 · S/N 123988N1054UPiper PA-34-200 · S/N 34-7250038First renewal noticeN123JCPiper PA-28-140 · S/N 28-22500N1517XPiper PA-28R-200 · S/N 28R-7535306N173YACessna 172P · S/N 17274191N174JWWard Dave RV-7A · S/N 73243N181VVCessna 150G · S/N 15065010N2291JFoster Jeffrey W VANS AIRCRAFT RV 14 · S/N 140475N2450EAeronca S7CCM · S/N 7AC-6030N256DSPdps Pzl-Bielsko SZD-56-1 DIANA · S/N 561101002N347RAS.O.C.A.T.A. RALLYE 150 ST · S/N 3100N44100Taylorcraft BC12-D · S/N 9900N4870MPiper PA-11 · S/N 11-389N5140GPiper PA-28-140 · S/N 28-7125073N5142BStinson L-5G · S/N 42-98774N5860DPiper PA-22-150 · S/N 22-4539N704UYCessna 150M · S/N 15078896N7341QCessna 182P · S/N 18260981N7348JPiper PA-28-140 · S/N 28-24698N738BRCessna 172N · S/N 17269853N7391WPiper PA-28-180 · S/N 28-1276N73HYAviat A-1B · S/N 2063N7433NCessna U206G · S/N U20603660N7479JPiper PA-28R-180 · S/N 28R-30835N7626YPiper PA-30 · S/N 30-700First renewal noticeN808LHawker Beechcraft 390 · S/N RB-244N808LRTextron 680A · S/N 680A0327N940LCSmith D H/Smith L J LANCAIR 235D · S/N DS-235DN94857Ercoupe E · S/N 4981N96310Taylorcraft BC12-D · S/N 8610N9842TPiper PA-38-112 · S/N 38-78A0223N9973ACessna 170A · S/N 19554
Back to Sherwood, AR