Snellville, GA
Registered aircraft · 328
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 = 'GA' AND g.registrant_city = 'SNELLVILLE' 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 = 'GA' AND g.registrant_city = 'SNELLVILLE' 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.
N1007LPiper PA-28R-201T · S/N 28R-7703403N1016TCessna T182T · S/N T18208371N104FFFuji FA-200-160 · S/N 145N105VECessna 208B · S/N 208B0680N108FBMaule MX-7-235 · S/N 10119CN109UVarga 2150A · S/N VAC-152-80N111HFBell 206B · S/N 208N111XEJaworski Reginald W GLASAIR RG · S/N 589N120ANNelson Arden W RV-9A · S/N 90511N121JLOdom Ron CHRISTEN EAGLE II · S/N ODOM 0001N123ESGulfstream American AA-5B · S/N 1021N123RKBeech F33A · S/N CE909N125GBGame Composites GB1 GAMEBIRD · S/N 0105N125WSSchmidt W William KITFOX · S/N 125N127AVPiper PA-28-181 · S/N 28-8490077N1280ZColumbia Aircraft Mfg LC41-550FG · S/N 41654N12NMMangold Michael E MANGOLD EDGE 540K · S/N 0036AKN12SUSukhoi SU-26M · S/N 01-02N13048Willis Donald Louie GLASAIR · S/N 374N13050Waco UEC · S/N 3678N1326KAviat PITTS S-2B · S/N 5310N132MKDan Hawken TITAN T-51 · S/N M02XXXC0HK0002N1344VBoeing E75 · S/N 75-8806N134JPPearce James L VELOCITY RG · S/N 170N134TTBeech A45 · S/N G-305N1381Pitts S-1C · S/N 69N141MPMooney M20L · S/N 26-0021N142MSPiper PA-28RT-201T · S/N 28R-8331017N150TVReims F150M · S/N F15001165N151HMRobinson Helicopter R44 II · S/N 10617N155AGBeech 95-B55 · S/N TC2311N1569DCessna 195 · S/N 7791N159WAWaco Classic YMF-F5C · S/N F5C-8-159N1605RGrumman American Avn. AA-1B · S/N AA1B-0605N1611HCessna 177RG · S/N 177RG0784N167AWCessna 340A · S/N 340A0537N16846Fairchild 24 C8E · S/N 2845N16HLPiper PA-28R-180 · S/N 28R-30675N1704MBoeing E75 · S/N 75-8595N1741GBeech G35 · S/N D-4773N175BACessna 170 · S/N 18516N18055Cessna 180 · S/N 31463N180WJCessna 180K · S/N 18052873N1815HCessna T210L · S/N 21061148N184KPBeech 3 TM · S/N CA-130N185ZACessna 185E · S/N 185-0983N1872VCessna 140 · S/N 14052N18796Cessna C-165 · S/N 403N188CTCirrus Design SR22 · S/N 2983N18923Ryan Aeronautical ST-A · S/N 322
Back to Snellville, GA