Villa Rica, GA
Registered aircraft · 34
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 = 'VILLA RICA' 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 = 'VILLA RICA' 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.
N15PKRobinson Helicopter R44 II · S/N 13256N167TPiper PA-18 · S/N 18-2281N208THPiper PA-32R-301 · S/N 3246122N230BCessna TU206A · S/N U206-0625N23GRRoth Gil SPARROW II-XTC · S/N CA-404N243TJRobinson Helicopter R44 II · S/N 10239N2479KPiper PA-38-112 · S/N 38-79A0659N28FFPiper PA-28-150 · S/N 28-208N2976LMooney M20C · S/N 670136N3284FMooney M20F · S/N 670377N3327PPiper PA-32R-301 · S/N 3213013N35264Cessna 177B · S/N 17702297N35FLCarroll G Allen VANS RV-7 · S/N 73167N421DSCessna 421C · S/N 421C0169N4275EPiper PA-38-112 · S/N 38-78A0521N50745Cessna 150J · S/N 15069524N5129XChampion 7KCAB · S/N 171N546CTFlight Design CTLS · S/N 07-11-15N61119Cessna A185F · S/N 18504110N6372VAlon A2 · S/N A-48N6420DNorth American SNJ-4 · S/N 88-13374N6530RCessna 172RG · S/N 172RG0199N6733JPiper PA-28-140 · S/N 28-24444N718QCPiper PA-32RT-300 · S/N 32R-7885135N7335TCessna R182 · S/N R18200029N824XGAerostar International RX 8 · S/N RX8-3143N8366LCessna 172I · S/N 17256566N8885HPiper PA-24 · S/N 24-2577N944HCCirrus Design SR22 · S/N 2659N946HCIsrael Aircraft Industries GULFSTREAM 100 · S/N 151N947HCCessna 525 · S/N 525-0077N948HCCirrus Design SR22 · S/N 0712N974BPLaird Bruce E JR PIETENPOL BIG PIET · S/N BP004N99997Ercoupe 415-C · S/N 2620
Back to Villa Rica, GA