Little Rock, AR
Registered aircraft · 215
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 = 'LITTLE ROCK' 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 = 'LITTLE ROCK' 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.
N103WAWheeler Automated SKYHMINI · S/N WAA2006UAVN106WAWheeler Automated SKYH · S/N WAA2007UAVN108CFDiamond Aircraft Ind DA 40 · S/N 40.479N108LZPiper PA-28RT-201 · S/N 28R-7918014N1110CBeech H35 · S/N D-5117N115MQSikorsky S-76D · S/N 761009N1213VCirrus Design SR22 · S/N 8981N12EVPiper PA-46-310P · S/N 46-8508065N131JKCirrus Design SR22T · S/N 11264N131LGDassault-Breguet MYSTERE FALCON 900 · S/N 055N133GLCessna 525 · S/N 525-0001N135BCEmbraer-Empresa Brasileira De EMB-505 · S/N 50500017N142WACirrus Design SR22T · S/N 9788N1444EHylio AG-116 · S/N 000272N152SBCirrus Design SR22 · S/N 1146N152WLBeech 200 · S/N BB-260N15BKKnox Robert H STARDUSTER TOO SA300 · S/N D.G.A.1N1625DCessna 170B · S/N 20267N1683WBeech 95-B55 (T42A) · S/N TC-1526N1737LCessna 182T · S/N 18282038N1747JPiper PA-28-140 · S/N 28-24165N179WCCessna 525B · S/N 525B0025N188RSBellanca 8GCBC · S/N 341-80N1990GTextron 680A · S/N 680A0013N204JMYoungblood Jimi PIONEER FLIGHTSTAR · S/N 000204N2075TCirrus Design SR20 · S/N 1075N20UCOstrem Frederick S LANCAIR 235 · S/N 148N210RZCessna 210L · S/N 21059529N2257VCessna 140 · S/N 14488N225PRBell 205A-1 · S/N 30230N227VJPilatus PC-24 · S/N 227N23LGPiper PA-24-250 · S/N 24-832N2410JCessna 150G · S/N 15065510N241SGMooney M20R · S/N 29-0196N254CHBeechcraft B200GT · S/N BY-173N255JPCirrus Design SR22 · S/N 3084N25MHHepperlen RV-8 · S/N 80540N2625HHays Monty B HAYS FLYER · S/N MBH001N26BDIsrael Aircraft Industries 1125 WESTWIND ASTRA · S/N 062N2722DCessna 170B · S/N 26889N2754UCessna 172D · S/N 17250354N27DTLee Eric Hall PIETENPOL · S/N EH-1N280SWCessna U206G · S/N 20604561N2901KCessna 180K · S/N 18053124N2972TAero Commander 200D · S/N 344N29DDBeech B-55 · S/N TC-1227N300TTBeech F33A · S/N CE-906N3019FCessna 182J · S/N 18257119N313GLTextron 525C · S/N 525C0255N317JSIsrael Aircraft Industries 1124A · S/N 385
Back to Little Rock, AR