Marietta, GA
Registered aircraft · 131
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 = 'MARIETTA' 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 = 'MARIETTA' 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.
N101CDCirrus Design SR22 · S/N 0101N1052UMaule MX-7-180C · S/N 28007CN109HSLee Byung DR-109 · S/N 040N10HWWilson Charles W RV-10 · S/N 40334N1159KCessna 172S · S/N 172S10357N115TBDassault FALCON 900 EX · S/N 605N127KSSchleicher ASW-27 · S/N 27097N151SFPiper PA-28-151 · S/N 28-7415411N156KTCirrus Design SR20 · S/N 1624N1592RGrumman American Avn. AA-5B · S/N AA5B-0092N1613HCessna 177RG · S/N 177RG0786N1765KLuscombe 8E · S/N 4492N177BGCessna 177B · S/N 17702449N180RMRich E Mcdevitt A600 TALON · S/N 8162 RMN18308Beech A36 · S/N E-1083N18400Beech B-60 · S/N P-412N18WECessna 680 · S/N 680-0317N201WDMooney M20J · S/N 24-0269N2032WBeech 35-C33 · S/N CD-977N20EBViorel Balanoiu RV-14A · S/N 140756N20FCCessna 182N · S/N 18260314N2148CMooney M20J · S/N 24-3405N2151XCessna 182T · S/N 18281233N215KYAircraft Mfg & Development CH 2000 · S/N 20-1045N2172CCessna 195B · S/N 16157N21HLPiper PA-31-350 · S/N 31-8152126N22318Cessna 150H · S/N 15068214N224YBCirrus Design SR22 · S/N 11048N229TTHawker Beechcraft G36 · S/N E-3929N233ZRobinson Helicopter R44 II · S/N 11991N2413ERyan Fitzgerald M24 ORION PLUS · S/N 24266596N24183Beech V35B · S/N D-10107N2498NCessna 140 · S/N 12751N2596APiper PA-22-135 · S/N 22-875N2602HEngineering & Research 415-C · S/N 3227N271SDPeter Fontaine SPORTSMAN 2+2 · S/N 7078N2736TBeech V35 · S/N D-8458N2739CCessna R182 · S/N R18200223N2795FCessna 182J · S/N 18256895Registration pendingN290JSStory Dewayne M LANCAIR 320-FB · S/N 716-320-560FBN3110ABeech 95-B55 (T42A) · S/N TC-2207N3127QSchempp-Hirth NIMBUS 3 · S/N 20N3178PHipps RELIANT · S/N 166N3239HErcoupe 415-C · S/N 3864N3368TCessna 177 · S/N 17700668Registration revokedN33EZRooke Kenny A LONG EZ · S/N 1420N343MAPiper PA-32R-301 · S/N 32-46183N34506Cessna 177B · S/N 17701846N34980Cessna 177B · S/N 17702132N350FJCessna LC42-550FG · S/N 421008
Back to Marietta, GA