Jonesboro, AR
Registered aircraft · 127
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 = 'JONESBORO' 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 = 'JONESBORO' 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.
N106FCRobinson Helicopter R44 II · S/N 13399N158BDBeech 58 · S/N TH-1045N182CJCessna 182E · S/N 18253671N191RLCommander 114-B · S/N 14575N205KCAir Tractor AT-802A · S/N 802A-0728N21425Piper PA-32RT-300T · S/N 32R-7887207N219JLLearjet 45 · S/N 267N231BLMooney M20K · S/N 25-0117N232CTBiter Cleon J RANS S-19 · S/N 031200107N236DSDiamond Aircraft Ind DA 40 · S/N 40.271N2380ZPiper PA-23-250 · S/N 27-8054031N250TXAuto Gyro MTOSPORT · S/N US10S01N2546YCessna 172D · S/N 17249846N268RJHudson David Allen HUDSON BUSHMASTER · S/N 001N2699FCessna 182J · S/N 18256799Registration pendingN2738WMooney M20D · S/N 260N2922QPiper PA-32R-300 · S/N 32R-7780268N292JDDJI AGRAS T40 · S/N 64TBL5H00200FQN302MDEmbraer EMB-500 · S/N 50000203N3074GChampion 7ECA · S/N 466N310VHCessna 310P · S/N 310P0180N31140Ercoupe 415-C · S/N 3143N313ETCirrus Design SR22T · S/N 0955N31MSAmerican Champion 8GCBC · S/N 593-2018N3228QPiper PA-32R-300 · S/N 32R-7780300N32671Piper J3F-65 · S/N 5530N329CSTextron T206H · S/N T20609637N32BKBellanca 7KCAB · S/N 412-74N32HRAeroprakt Mfg SP Z O O A32 · S/N 241N333MMNeil Corella VANS RV 10 · S/N 40399N334WCRobinson Helicopter R44 · S/N 30009N35CENorth American/Walbrun T6-G · S/N 168-89GWN3611KPiper J3C-65 · S/N 22300N3669SCessna 172E · S/N 17250869N3833XDavid R Craft RANS DSGN S6ES COYOT · S/N 04991318N383PDBell UH-1H · S/N 68-16383N38804Piper PA-28-181 · S/N 28-7790589N3979LCessna 172G · S/N 17254148N39AUAero Vodochody L39C · S/N 031603N41171Champion 7ECA · S/N 735-70N4121YBellanca 7ECA · S/N 1176-76N41687Air Tractor AT-802A · S/N 802A-0309N42141Cessna 182L · S/N 18258871N4248QCessna 172L · S/N 17260148N42955Cessna 182L · S/N 18259265N432MTCessna 206H · S/N 20608159N4397VRaven Industries RALLY RX7 · S/N RX7-366N44275Piper PA-28-151 · S/N 28-7415613N4482WRaytheon 58 · S/N TH-1964N448TAmerican Champion 8GCBC · S/N 635-2023
Back to Jonesboro, AR