Macon, GA
Registered aircraft · 89
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 = 'MACON' 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 = 'MACON' 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.
N529LHTextron G58 · S/N TH-2517N5325HPiper PA-16 · S/N 16-130N5473BCessna 182 · S/N 33473N555ERCessna 182S · S/N 18280068N568PCCessna 551 · S/N 551-0500N56KMBeech 58 · S/N TH-1391N5794LAmerican AA-1 · S/N AA1-0194N5976RCessna 172G · S/N 17253645N59EKBeech F90 · S/N LA-58N60435Cessna 182T · S/N 18281840N613PFCessna 182T · S/N 18281139N633TZTowery D T II / Zammetti A J GN 1 AIRCAMPER · S/N 1747N6558WPiper PA-28-140 · S/N 28-20639N65LMRaytheon 58 · S/N TH-1902N667MTCirrus Design SR20 · S/N 2194N715GFThrush S2R-H80 · S/N H80-204DCN716GFThrush S2R-H80 · S/N H80-211DCN72108Beech A36 · S/N E-2197N734JMaule M-7-235B · S/N 23091CN7407HPiper J3C-65 · S/N 20665N74267Bellanca 14-13 · S/N 1380N74BABeech B-60 · S/N P-569N7579WPiper PA-28-180 · S/N 28-1515N7659JPiper PA-28R-180 · S/N 28R-31059N777TKBeech 58 · S/N TH-1018N787MDCessna 182T · S/N 18282308N797RACessna 414A · S/N 414A0119N813HCCessna 182T · S/N 18281460N8335UCessna 172F · S/N 17252235N83KKRaytheon 58 · S/N TH-1781N858TCBeech 58TC · S/N TK-98N87919Piper J3C-65 · S/N 15537N87TMCessna A185E · S/N 18501786N8899PPiper PA-24-260 · S/N 24-4353N903CTDiamond Aircraft Ind DA20-C1 · S/N C0103N91MJEmbraer Executive EMB-500 · S/N 50000441N942MBIai GULFSTREAM G280 · S/N 2013N9525MMooney M20F · S/N 670102N9FVCessna 182S · S/N 18280106
Back to Macon, GA