Springdale, AR
Registered aircraft · 93
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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.
N101AXBeech B-60 · S/N P427N102FABeech 95-A55 · S/N TC-483N1107FCessna 172G · S/N 17254702N111HKTextron 182T · S/N 18282377N1154EAeronca 7AC · S/N 7AC-4710N1196XPiper PA-28-140 · S/N 28-7525279N1229WWilliams Dan GLASTAR · S/N 5258N123WECessna 177RG · S/N 177RG0628N131NTemco D-16A · S/N TTN-65N1410GCessna 150L · S/N 15073205N1440GCessna 150L · S/N 15072955N150JJCessna 150L · S/N 15072231N1534YCessna 172C · S/N 17249234N163WCessna 170B · S/N 27094N1807CCessna 170B · S/N 25951N214NYBarker Andrew H RV-4 · S/N 899N223KWBeech B36TC · S/N EA-382N231MCHawker Beechcraft G36 · S/N E-3858N233AGAutogyro USA II CALIDUS · S/N US-C00538N250ZHelicopteres Guimbal CABRI G2 · S/N 1223N2573WMooney M20C · S/N 3274N259MAero Commander 200D · S/N 297N2702WMooney M20C · S/N 3329N29DXCirrus Design SR22T · S/N 2158N3051CBeech J35 · S/N D-5707N3079ZMaule MX-7-180A · S/N 20007CN30SHPiper PA-30 · S/N 30-1262N319ENEnstrom Helicopter F-28A · S/N 319N3224WPiper PA-32-260 · S/N 32-31N3260YCessna 182E · S/N 18254260N328SBeech V35A · S/N D-9068N32WWWillmott Webb B RV7A · S/N 72384N3316JCessna 150G · S/N 15066016N332CDCirrus Design SR22 · S/N 0873N340MPCessna 340A · S/N 340A0359N341UBeech E-55 · S/N TE-826N3423TCessna 177 · S/N 17700723N34375Meyers MAC-145 · S/N 218N35498Cessna 210L · S/N 21059996N3775NWeldon Wesley W BAKENG DUCE · S/N WW1N38DVBeech 36 · S/N E-83N3944RCessna 172H · S/N 17255444N41XEBeech C35 · S/N D-2871N430DMCessna T206H · S/N T20609078N449MASocata TBM 700 · S/N 1083N4540JPiper PA-28R-180 · S/N 28R-30399N45DHBeech D55 · S/N TE-718N46MUEnstrom F-28A · S/N 253N4791CCirrus Design SR22T · S/N 1725N479WGWill Gilbrech MODEL 4 · S/N C94050027
Back to Springdale, AR