Senoia, GA
Registered aircraft · 75
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 = 'SENOIA' 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 = 'SENOIA' 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.
N1011UKerner Melvin F POBER JR ACE · S/N 157N101RVBerthe C J JR VANS RV-3B · S/N 776N111WFCessna 180 · S/N 31243N11596Cessna 177B · S/N 17702352N13GYLiu Gwoho H RV-8A · S/N 81355N1452PPiper PA-23 · S/N 23-515N15641Brunner-Winkle BIRD A · S/N 1000N1678ZCessna 185A · S/N 1850470N18645Cessna 150L · S/N 15074011N1937QAirborne Windsports XT 912 · S/N XT91259N214EAeropro CZ S R O A220 · S/N 61221N214MCBeech N35 · S/N D-6772N22546Stinson HW75 · S/N 7128N23209Piper J3F-65 · S/N 2985N246AHAndrew J Renwick STOLP STARDUSTER 2 S · S/N 345N2676PNorth American SNJ-5 · S/N 85066N26FSCessna 150 · S/N 17799N2703KLuscombe 8A · S/N 5430N277CKJones Doug L RV-10 · S/N 40761N312ABPiper PA-28R-201T · S/N 28R-7803120N327HPPiper PA-32R-301T · S/N 3257152N3616QSchweizer SGS 2-33A · S/N 567N378TBeech P35 · S/N D-7149N407JAJust HIGHLANDER · S/N JAESC0119N409JAMark Sorenson HIGHLANDER · S/N JAESC255N41477Piper PA-28-180 · S/N 28-7405107N4210BBellanca 17-30A · S/N 75-30757N4224TPiper PA-28-180 · S/N 28-7205105N422CHVip Aircraft Management HIGHLANDER · S/N JA 233-03-11N4326LPiper PA-28-181 · S/N 28-8490015N4401CCessna 195A · S/N 7986N44CYBeech 95-B55 (T42A) · S/N TC-1629N47599Piper PA-28-181 · S/N 28-7890101N48130Estes BREEZY · S/N 76N49988Cessna 152 · S/N 15281428N5073WCessna 305A · S/N 21096N517JVDJI INSPIRE 1 · S/N W13DCE11031557N520ETThomason Edward J MILLS SPECIAL · S/N JM-12N5229DCessna 172N · S/N 17272459N5459ZPiper PA-22-108 · S/N 22-9237N5615ECessna 150 · S/N 17115N5755ZPiper PA-22-108 · S/N 22-9597N5789FPiper PA-28-140 · S/N 28-25096N596HPPiper PA-32R-301 · S/N 3246052N5970GCessna 150K · S/N 15071470N61832Cessna 172M · S/N 17264828N6316RPiper PA-28-140 · S/N 28-21482N6372JPiper PA-28-180 · S/N 28-4785N6463JPiper PA-28-180 · S/N 28-4886N650BBeech H35 · S/N D-5100
Back to Senoia, GA