Griffin, GA
Registered aircraft · 86
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 = 'GRIFFIN' 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 = 'GRIFFIN' 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.
N111DZPiper PA-60-602P · S/N 60-8265014N111EPiper PA-24-260 · S/N 24-4210N11331Cessna 150L · S/N 15075334N1451GBeech 95-A55 · S/N TC-249N15956Piper PA-28-180 · S/N 28-7305196N15PBeech D-50 · S/N DH-92N164CMScecina Michael/French Craig C RV-6 · S/N 24363N16508Waco YKS-6 · S/N 4509N1748GBeech 35-B33 · S/N CD-527N202TMMitchell William T ESCAPADE · S/N 010N2090VPiper PA-28-181 · S/N 28-7990339N2376JBeech 23 · S/N M-339N238TFVans RV-12IS · S/N 121252N24440Cessna 182T · S/N 18280956N2496APiper PA-18 · S/N 18-1963N2535ESocata TB-20 TRINIDAD · S/N 876Sale reportedN25907Cessna 152 · S/N 15280849N2685NCessna 140 · S/N 12943N2696TPiper PA-28-180 · S/N 28-7205087N2980RPiper PA-28R-200 · S/N 28R-35368N3175PBeech F33A · S/N CE-1091N3306Let L 33 SOLO · S/N 930106N338SSPiper PA-23-250 · S/N 27-224N360TBBrown Thomas D PITTS S-12 · S/N 0010N3704QBeech V35 · S/N D-8365N377SSwords Donald H HATZ CB-1 · S/N 264N3889JCessna 150G · S/N 15065189N3973HEngineering & Research 415-CD · S/N 4674N40607Piper J3C-65 · S/N 7358N41554Piper PA-28-140 · S/N 28-7425259N415CUniversal Stinson 108-2 · S/N 108-3415N41813Bellanca 7GCBC · S/N 603-73N42794Piper J3C-65 · S/N 15108N4299HPiper PA-14 · S/N 14-103N4476HPiper PA-15 · S/N 15-265N4666HPiper PA-17 · S/N 17-71N4679HMooney M20J · S/N 24-0808N512CLLedbetter Donald Steven HELICYCLE · S/N 4-27N5229TPiper PA-28R-200 · S/N 28R-7235002N5278GCessna 305A · S/N 22732N5287JAerostar International S-49A · S/N S49A-3216N536ABellanca 14-19 · S/N 2089N5419NCessna 182Q · S/N 18267702N5445RCessna 172F · S/N 17252997N545PGGore James Roy JR RV-10 · S/N 40565N5492NPiper J3C-65 · S/N 12105N5627TCessna 172E · S/N 17251527N5811GCessna 150K · S/N 15071311N584CACommander 114-B · S/N 14584N5944RCessna 172G · S/N 17253613
Back to Griffin, GA