Lonoke, AR
Registered aircraft · 53
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 = 'LONOKE' 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 = 'LONOKE' 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.
N1269UAdamson Don STITS SA3A · S/N P-744N1300SStolp-Starduster Too SA 300-A · S/N 13N13SCRobbie Staton PA 18 REPLICA · S/N JA2101151N1455NPiper J3C-65 · S/N 22989N150LKCessna 150G · S/N 15065029N1589BLuscombe T-8F · S/N 6216N196BCWilliam M Clapp CORWITT · S/N CLAPP03N22ANorth American NAVION · S/N NAV-4-19N241NXHuss Leon J ONEX · S/N ONX-0102Registration pendingN24PNMessinger Norman G RUTAN LONG-EZ · S/N 479N26008Piper PA-38-112 · S/N 38-81A0097N26739Piper J3C-65 · S/N 4151N2KVMolino PIK-20 · S/N 20036N30JGGilson STARDUSTER TOO SA300 · S/N 1369N315CUniversal Stinson 108-2 · S/N 1083315N315PKCessna R172K · S/N R1722742N3239QCessna 401 · S/N 401-0039N3509WBeech 58 · S/N TH-350N3589Schleusner STARDUSTER II SA-300 · S/N 680Sale reported, pending cancellationN3700EAeronca 11AC · S/N 11AC-1853N372TCCYR Ted GS-1 · S/N 5902N37966Harker Edward W ACRO DUSTER II · S/N 1N401KCessna 401 · S/N 401-0038N426TRRumsey Todd A KELEHER LARK JK-2A · S/N TAR-1N4800KRyan NAVION A · S/N NAV-4-1800N495BSRuth Swantek PITTS 12 · S/N 320N503GLGreat Lakes 2T-1A-1 · S/N 0503N5103ZPiper PA-22-108 · S/N 22-8739N528RLDJI AGRAS T50 · S/N 1581F6BUB248D001P7E3N580PSDon Adamson PITTS MODEL 12 · S/N 400N5994WPiper PA-28-140 · S/N 28-24799N6516LGrumman American Avn. AA-1B · S/N AA1B-0316Sale reportedN686JBHeiner Bruce L STARDUSTER II · S/N 1003N689ATSport Trainer Project CLIPPED-WING CUB · S/N 1776N7001ZAirframes Unlimited T2 · S/N ALK001N70TNSlingsby TYPE T-50 SKYLARK 4 · S/N 1343N7327VBellanca 17-30 · S/N 30182N7344XCessna 150B · S/N 15059444N7574MCessna 175 · S/N 55874N7767RAdamson Don PITTS MODEL 12 · S/N 130N788ZZimmerman STARDUSTER TOO · S/N 670N815JRJames Robbins III PIETENPOL · S/N JR001N82355Aeronca 7DC · S/N 7AC-987N83635Champion AERONCA 7BCM · S/N 7AC-2313N8660VBellanca 7GCAA · S/N 314-75N878DAPiper PA-28-140 · S/N 28-7125620N8891UCessna 172F · S/N 17252810N8TJStarduster SA-300 · S/N GJS-1000N9081JPiper PA-28-180 · S/N 28-3118N91831Cessna 182M · S/N 18259926
Back to Lonoke, AR