Carrollton, GA
Registered aircraft · 59
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 = 'CARROLLTON' 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 = 'CARROLLTON' 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.
N11676Bellanca 7GCAA · S/N 236-72N1198Piper PA-18-135 · S/N 18-3334N122DTCessna 182S · S/N 18280908N13SJWoolley Robert H WOOLLEY GLASAIR SH1 · S/N 639N1401NPiper J3C-65 · S/N 22925Registration pendingN1545ECessna 172N · S/N 17271042N16JGame Composites GB1 GAMEBIRD · S/N 0092N178DCDehavilland DHC-1B-2-S3 · S/N 178N18DZZander Denell D THORP T-18 · S/N 551N1906FCessna P206E · S/N P206-0001N211BBeech 95-B55 (T42A) · S/N TC-714N23495Piper J3C-65 · S/N 3212N24608Beech A24R · S/N MC-142N260GBSIAI Marchetti F.260C · S/N 725N3080UScheibe L SPATZ III · S/N 820N322CHRyan Christopher C RV-8 · S/N 82992N3265JCessna 150G · S/N 15065965N33579Piper J3C-65 · S/N 14056N35569Cessna 172I · S/N 17256841N364ACRaytheon A36 · S/N E-3148N3838KBoeing E75 · S/N 75-8079N4138UCessna 150D · S/N 15060138N49BBSiai-Marchetti SF.260TP · S/N 037N506GBPilatus PC-9/A · S/N 506N5166ACessna 172 · S/N 28166N52751Cessna 182P · S/N 18262819N52GWWood George E HIPERBIPE SNS-7 · S/N 224N536LTextron 182T · S/N 18283023N548BGPilatus PC-9/A · S/N 548N54DGBeech A36 · S/N E-1562N568SRCirrus Design SR22 · S/N 1083N56EFDehavilland DHC-1B-2-S5 · S/N 194232N581DBPilatus B4-PC11AF · S/N 262N6008ACessna 172 · S/N 28608N628TCAmerican Champion 7GCBC · S/N 1212-95N6419JPiper PA-28-180 · S/N 28-4836N663GMMoman Guy E JR PITTS S-1D · S/N GM-6N663TAirborne Windsports XT 912 · S/N XT-912-119N66JEmbraer Executive EMB-505 · S/N 50500575N7047SCessna 150H · S/N 15067747N71046Piper J3C-65 · S/N 18067N73041Cessna 172M · S/N 17267248N737BECessna 172N · S/N 17269285N7517URobinson Helicopter R22 BETA · S/N 3510N7599LPiper PA-31-310 · S/N 31-7400988N777DKBeech 95-C55 · S/N TE-443N8088KStinson 108-2 · S/N 108-3088N818TCessna 152 · S/N 15283216N81FKCirrus Design SR22 · S/N 4878N830RSAdventure Flying CCX-1865 · S/N CCX-1865-2009
Back to Carrollton, GA