Springdale, AR
Registered aircraft · 93
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 = 'SPRINGDALE' 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 = 'SPRINGDALE' 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.
N4876YCessna T210N · S/N 21064025N4878Enstrom F-28A · S/N 029N5117ACessna 172 · S/N 28117N51778Enstrom F-28C · S/N 451-2N5190XChampion 7ECA · S/N 690N522ARCirrus Design SR22 · S/N 1534N5296ACessna P210R · S/N P21000847N545CGLearjet 45 · S/N 386N551BWBeech F33A · S/N CE-1431N5556DBeech H35 · S/N D-5078N5621ACessna 172 · S/N 28221N5998FCessna 210H · S/N 21058998N6155PPiper PA-24 · S/N 24-1256N6487BCessna 172 · S/N 29687N67NGPiper PA 46-350P · S/N 4636727N7296TCessna 172A · S/N 46896N739GUCessna 172N · S/N 17270539N757ZACessna 152 · S/N 15280123N76207Cessna 120 · S/N 10610N762BBeech J35 · S/N D-5511N7738NPiper PA-28-180 · S/N 28-5182N8062SCessna 150F · S/N 15061662N809TSBeech 35 · S/N D-809N812TSNYS John M RV-12 · S/N 120292N8269LCessna 172H · S/N 17256469N8599BCessna 172 · S/N 36299N8653MBeech 35-B33 · S/N CD-674N8704RHafemeister Roy H GENESIS · S/N RH-01N8830TCessna 182C · S/N 52730N9019XCessna 182D · S/N 18253419N902TFDassault FALCON 2000EX · S/N 369N9050GCessna 182N · S/N 18260590N907RPCessna 680 · S/N 680-0251N913TDCessna 525 · S/N 525-0468N9162BCessna 172 · S/N 36762N9169QBeech A36 · S/N E-253N92610Piper PA-32R-301 · S/N 3246014N9334LAmerican AA-1A · S/N AA1A-0034N9568Enstrom F-28A · S/N 091N9604Enstrom F-28A · S/N 154N989AGCurtis H Laub AUTOGYRO MTO SPORT · S/N M00918N9913ECessna 182P · S/N 18263973N9998ACessna 170A · S/N 19433
Back to Springdale, AR