Rogers, AR
Registered aircraft · 82
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 = 'ROGERS' 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 = 'ROGERS' 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.
N1017GMooney M20K · S/N 25-0547N121APGulfstream Aerospace G-IV · S/N 1239N126ATSea & Sky CYGNET · S/N 20134N129SJExtra Flugzeugbau EA 300/L · S/N 129N151AJEllzey Andrew James VELOCITY XL-RG · S/N 3RX-151N17818Beech F33A · S/N CE-710N179BWAviat A-1C-180 · S/N 3029N17QCTextron 525B · S/N 525B0509N1889JPiper PA-28-140 · S/N 28-24334N192BCCirrus Design SR22T · S/N 10246N19971Cessna 172M · S/N 17260898N20224Beech V35B · S/N D-10159N211CKCirrus Design SR22T · S/N 1025N212MHRaytheon A36 · S/N E3209N223CSamuel S Chambers HAWK · S/N HA II-300-582-TDN2259MCessna 150M · S/N 15077090N2354BBeech V35A · S/N D-8831N250YBeech 35-C33 · S/N CD-1065N2532YCessna 172D · S/N 17249832N2623HEngineering & Research ERCOUPE 415-C · S/N 3248N2660PPiper PA-22-150 · S/N 22-3000N268TZTextron 182T · S/N 18283108N27682Piper PA-31-350 · S/N 31-7852105N280WREnstrom Helicopter 280C · S/N 1108N28962Ercoupe 415-C · S/N 58N29DCBeech S35 · S/N D-7943N3025LPiper PA-32RT-300T · S/N 32R-7987092N30PPeck JODEL-F12 · S/N F8027N32436Piper PA-28-140 · S/N 28-7525067N331APCirrus Design SR22 · S/N 5109N3442TCirrus Design SR22 · S/N 3710N3657QBeech B23 · S/N M-1136N3842DEnstrom 280FX · S/N 2128N38562Piper PA-32R-300 · S/N 32R-7780442N403TSSeratt Timothy G STOL 1 · S/N 001N405KTPiaggio Aero Industries P180 · S/N 1190N4159FPiper PA-34-200T · S/N 34-7670328N421WPCessna 421C · S/N 421C0417N424RGGruetzmacher Randy RAN 2000 · S/N 31BSGN43029Taylorcraft BC12-D · S/N 6688N433BTBailey Jon C PITTS MODEL 12 · S/N 87N44283Taylorcraft BC12-D1 · S/N 10083N4530DGulfstream American AA-5B · S/N AA5B1153N4801PCessna P210N · S/N P21000113N5017BBeech F35 · S/N D-4281N50862Taylorcraft DCO-65 · S/N 4605N534CTFlight Design CTSW · S/N 07-03-17N5488JCessna 310R · S/N 310R0286N554UTCirrus Design SR22 · S/N 9014N557DRRobinson Dennis DR FLOATER · S/N 01
Back to Rogers, AR