Fayetteville, GA
Registered aircraft · 132
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 = 'FAYETTEVILLE' 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 = 'FAYETTEVILLE' 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.
N104STFlandermeyer Scott R RV-10 · S/N 40816N11395Cessna 150L · S/N 15075384N11751Monocoupe 90A · S/N A-680N1206KCessna 421C · S/N 421C1804N1235CBeech F33A · S/N CE-1235N13469Cessna 172M · S/N 17262773N140GDGlenn A Duralia VANS RV-14A · S/N 140140N1487TPiper PA-28-180 · S/N 28-7205307N1508HHelton LARK 95 · S/N 9508N156XPiper PA-32-300 · S/N 32-7840156N161JLLake LA-4 · S/N 346N1710HCessna 310C · S/N 35810N180AMMalecha A C RV-6A · S/N 60184N182TBeech D95A · S/N TD-687N18587Cessna 150L · S/N 15073965N1995TPiper PA-28-180 · S/N 28-7105219N2007PPiper PA-23 · S/N 23-579N204BMBell UH-1H · S/N 68-15683First renewal noticeN2050RCessna 182G · S/N 18255250N21402Cessna 182P · S/N 18261613N214CRBeech AT-11 · S/N 41-9486N214SWJohn Stone Ware IV RV-14 · S/N 140087N223ACChristensen Aaron M VANS RV-7A · S/N 73060N2249ECessna 172N · S/N 17271204N229SGCirrus Design SR22 · S/N 1956N234RBBeech 95-B55 (T42A) · S/N TC-1950N2507LLancair LC41-550FG · S/N 41106N2519QSocata TB 10 · S/N 1155N283SXBumpous Glenn T SONERAI-I · S/N 283N2863ACessna 180 · S/N 30063N2875UCessna 172D · S/N 17250475N2939PConsolidated Aeronautics LAKE LA-4-200 · S/N 946N2953GAmerican Champion 7GCAA · S/N 586N301JBBaker James P VANS RV-8 · S/N 82028N315ATJohn G Hess AT-5 · S/N 001N317MRRoy S Marlow/Daniel P Rothhaar RV7A · S/N 73213N31CHMidget Mustang MM-1 · S/N 532N327LWCessna 182C · S/N 52360N333APTaylor David D RV7A · S/N 74918N34793Superior CULVER LFA · S/N 246N34RAPiper PA-30 · S/N 30-342N353RVDarley Vo/Kilgore Dm/Castlen S RV-10 · S/N 40327N3584GAerostar International RAVEN S57-A · S/N S57A-3094N3630MPiper PA-28R-201T · S/N 28R-7803182N364STPiper PA 46-350P · S/N 4636364N367TTTurner Thomas M RV-8 · S/N 81738N367TVThomas M Turner RV-14A · S/N 140797N3750VCessna 150M · S/N 15076610N37533Beech E-55 · S/N TE-1063N3815EPiper PA-30 · S/N 30-1335
Back to Fayetteville, GA