Hickory, NC
Registered aircraft · 80
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 = 'HICKORY' 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 = 'HICKORY' 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.
N100LWPiper PA-32-301 · S/N 32-8006091N1064UMooney M20J · S/N 24-3295N119PCMooney M20J · S/N 24-0874N1206JIrwin Jeffrey C BUCCANEER BIIB · S/N BIIBK005N1391SCessna 182P · S/N 18264952N1629RGrumman American Avn. AA-1B · S/N AA1B0629N18439Stinson SR-9C · S/N 5325N18565Cessna 150L · S/N 15073946N191MMilburn Patrick E RV-6 · S/N 20109N1938DBeech C35 · S/N D-3214N1LRPiper PA-24-180 · S/N 24-2274N20929Cessna 182P · S/N 18261301N20EDBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1503N2184CFirefly Balloons FIREFLY 7B-15 · S/N F7B-2010N22502Stinson HW75 · S/N 7076N22CYCirrus Design SR22 · S/N 3085N238ARCirrus Design SR22 · S/N 0346N2517RPiper PA-28-180 · S/N 28-5640N255BVBombardier BD-100-1A10 · S/N 20644N27KVTextron T240 · S/N T24002094N27LTPiper PA-32R-301 · S/N 32R-8213060N283RCRex Alan Chamberlain JUST ACFT HIGHLANDER · S/N JA728-06-24N28CQNorth American T-28C · S/N 146254N31873Aeronca 65-TC · S/N L9191TN328CRBeech 200 · S/N BB-548N334FBeech D-45 · S/N BG-316N371VPCessna 510 · S/N 510-0371N3755WPiper PA-32-260 · S/N 32-670N375SRTextron T206H · S/N T20609616N3766RCessna 337D · S/N 337-1034N40RKVans RV-12 · S/N 120622N428PMP&M QUIKR · S/N 8428N4320TPiper PA-32R-301 · S/N 3213014N4352XPiper PA-28-180 · S/N 28-7505191N46JKPiper PA-46-310P · S/N 4608105N47ADHughes Danny R VANS RV-7A · S/N 71013N4897ECessna 172N · S/N 17271674N5119VQuad City Ultralight Acft CHALLENGER II · S/N CH20893R1009N514EDCirrus Design SR22 · S/N 1420N515MMLancair LC41-550FG · S/N 41046N525WGSocata TBM 700 · S/N 525N540SCDehavilland DHC-1B-2 · S/N 139N5588ZPiper PA-22-108 · S/N 22-9397N56015Piper PA-28-180 · S/N 28-7305518N5604GSix Chuter SR7 XL · S/N 98-2085-SR7X1N5644DBeech E18S-9700 · S/N BA-360N5704UPiper PA-28-140 · S/N 28-26501N580EBeech 58 · S/N TH-1758N5922KStraley Joseph Paige PRECEPTOR PUP · S/N JPS001N611BLCessna 560XL · S/N 560-5821
Back to Hickory, NC