Huntersville, NC
Registered aircraft · 52
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 = 'HUNTERSVILLE' 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 = 'HUNTERSVILLE' 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.
N112DFSchempp-Hirth VENTUS-2C · S/N 59N13DEBrunkalla George F RV-7A · S/N 71716N15117Stinson SR-6B · S/N 9608N15KKBeech AT-11 · S/N 4000N192FCPiper PA-28-140 · S/N 28-24374N19916Cessna 172M · S/N 17260859N23438Piper J3C-65 · S/N 3191N24NFAviat A-1C-180 · S/N 3165N258VWinings James O F-1 ROCKET · S/N 34N301PKPiper PA-32-300 · S/N 32-7440064N3057ZPiper PA-28RT-201 · S/N 28R-7918122N32RHRaytheon C90A · S/N LJ-1268N337JLCessna 337B · S/N 337-0708N34330Meyers OTW · S/N 75N35SFHawker SEA FURY TMK 20 · S/N 37537N3706NMooney M-20G · S/N 680044N3870UBeech 77 · S/N WA-260N3880DCessna 182A · S/N 34580N400DHCanadair CL-600-2B16 · S/N 5371N42263Piper J3C-65 · S/N 14513N42558Piper J3C-65 · S/N 14837N46RDLet BLANIK L-13 · S/N 174129N513JGVashon RANGER R7 · S/N 10143N51500Piper J3C-65 · S/N 9616N518JGBombardier CL-600-2B16 · S/N 5545N519JGBombardier CL-600-2C10 · S/N 10217N520JGBombardier CL-600-2C10 · S/N 10052N5251NCessna 182Q · S/N 18267600N5498CCessna 170A · S/N 19602N5952GCessna 150K · S/N 15071452N595JGBell 427 · S/N 56026N6135BIar Sa Brasov IAR 823 · S/N 45N6137JPiper PA-32R-300 · S/N 32R-7680309N615JHPiper J3C-65 · S/N 19633N636GTSocata TB-20 TRINIDAD · S/N 2031N69HBeech D17S · S/N 4896N709CCPiper PA46R-350T · S/N 4692030N709TLEpic E1000 · S/N K062N736DVCessna R172K · S/N R1722453N75057Piper PA-28-151 · S/N 28-7615243N7591UCessna 150M · S/N 15077758N7701HPiper PA-12 · S/N 12-592N777TLBeech V35 · S/N D-8302N7798WPiper PA-28-180 · S/N 28-1783N82914Piper PA-18-150 · S/N 18-7809023N8610NPiper PA-28R-200 · S/N 28R-7135131N87493Republic RC-3 · S/N 44N9013WPiper PA-28-235 · S/N 28-10596N9022KPiper PA-28R-201T · S/N 28R-7803059N93PDStinson 108-2 · S/N 108-373
Back to Huntersville, NC