Gold Hill, NC
Registered aircraft · 29
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 = 'NC' AND g.registrant_city = 'GOLD HILL' 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 = 'NC' AND g.registrant_city = 'GOLD HILL' 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.
N174PBRobert W Korff JR RV-7 · S/N 71157N20558Gaffney Sheldon TITAN TORNADO II · S/N D98912COHK0317N22321Aeronca 65-C · S/N C-3239N23518Aeronca 65-C · S/N 4999N242EEPiper PA-38-112 · S/N 38-78A0494N2613NCessna 120 · S/N 12873N2800ZPiper PA-22-150 · S/N 22-6793N3194CBeech V35 · S/N D-8479N3311APiper PA-22-135 · S/N 22-1586N33274Cessna 177RG · S/N 177RG0940N33733Piper PA-28R-200 · S/N 28R-7535184N342MLBrantly B-2B · S/N 343N403WRRumburg William LANCAIR 320 · S/N 403N41412Piper PA-28-151 · S/N 28-7415204N42969Piper J3C-65 · S/N 15328N435QWGrove Robert I RAF 2000 · S/N H2-93-4-102N4428HPiper PA-15 · S/N 15-213N442MLMooney M20E · S/N 978N4432ABeech V35B · S/N D-9144N5050TDJI AGRAS T100 · S/N 1581F8ZLC25BW002PLPXN52881Cessna 177RG · S/N 177RG1298N5437XJeffrey S Wilson SLING TSI · S/N 329SKN57947Boeing A75N1(PT17) · S/N 75-4392N6099XMooney M20A · S/N 1700AN668LAllen William M LANCAIR 235 · S/N 122N689TCAutogyro USA CALIDUS · S/N US-C00482N7069QCessna 172L · S/N 17260369N89217Cessna 140 · S/N 8237N9440FHughes 269B · S/N 55-0195
Back to Gold Hill, NC