Warner Robins, GA
Registered aircraft · 56
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 = 'WARNER ROBINS' 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 = 'WARNER ROBINS' 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.
N106GCCessna 172M · S/N 17264663N1250PParton James E RV6A · S/N 20876N139TSpicer Henry A PANTHER LS · S/N P002N16FSBeech N35 · S/N D-6800N172XXCessna 172A · S/N 47123First renewal noticeN1794TPiper PA-28-140 · S/N 28-7125133N17BRBeech 58 · S/N TH-1372N189DWDonald Wiltse VANS RV-9A · S/N 90080N1GPEngels GP-1 · S/N 001N235SMBeech 58 · S/N TH-926N2472EAeronca 7AC · S/N 7AC-6051N2876TPiper PA-28-140 · S/N 28-7225261N2966DCessna 170B · S/N 26909N2988KCessna 180K · S/N 18053151N3107XCessna 150F · S/N 15064507N33142Piper PA-28R-200 · S/N 28R-7535126N33JFPiper PA-30 · S/N 30-820N35BFS.O.C.A.T.A. MS894A · S/N 11722N367DBeech A36 · S/N E-1619N38475Piper J3F-65 · S/N 7047N384DSDiamond Aircraft Ind DA 40 · S/N 40.1037N4167FCessna 172 · S/N 46067N4174WPiper PA-32-300 · S/N 32-40253N4213RPiper PA-32-300 · S/N 32-40578N5037NBellanca 8KCAB · S/N 480-79N528REEdmisten Robert Eugene SR RANS S-14 AIRAILE · S/N 0803133N52TDCessna 170B · S/N 20379N536AMBeech A36 · S/N E1172N545MPWilson Peter M/Powrachute PEGASUS · S/N A-237-PEGN6055EBeech K35 · S/N D-6010N6104PPiper PA-24-250 · S/N 24-1202N6606JPiper PA-28-180 · S/N 28-5067Sale reported, canceledN6621JPiper PA-28-180 · S/N 28-5087N6762PPiper PA-24-250 · S/N 241892N6851MStinson 108-3 · S/N 108-4851N699WSCessna 310Q · S/N 310Q1050N700SEConrad Booze RV-10 · S/N 40851N727AMSchleicher ASW-20 · S/N 20273N7616RBeech B23 · S/N M-1239N767JGPiper PA-32-260 · S/N 32-52N7862GCessna 172L · S/N 17259562N7897TCessna 172A · S/N 47497N8092LTennyson Howard BASLEE DR-1 FULL SCA · S/N F106ABN81360Grumman American Avn. AA-5B · S/N AA5B0509N81411Aeronca 7AC · S/N 7AC-28Sale reportedN8148JPiper PA-28-161 · S/N 28-8016248N8217NPiper PA-28-140 · S/N 28-25421N823WIar Sa Brasov IAR 823 · S/N 25N835PJDJI INSPIRE 2 · S/N 09YDDCS0041672N83651Aeronca 7AC · S/N 7AC-2329
Back to Warner Robins, GA