Kernersville, NC
Registered aircraft · 37
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 = 'KERNERSVILLE' 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 = 'KERNERSVILLE' 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.
N10481Maule MXT-7-180A · S/N 21036CN10RACirrus Design SR22 · S/N 5069N136CHHall Charles A VANS RV4 · S/N 449N1707DCessna 170A · S/N 20150N181PGPiper PA-28-181 · S/N 28-7790584N2380DCessna 170B · S/N 20532N24XZPilatus PC-12/47E · S/N 1657N2647EAeronca 7AC · S/N 7AC6229N2999LMooney M20C · S/N 670104N3079HHarmenings HIGH FLYERS · S/N 5847N310GSPiper PA-28-181 · S/N 28-8090140N348SACessna 177B · S/N 17702065N383PRaytheon A36 · S/N E-3430N41858Piper PA-28-151 · S/N 28-7415338N42GCOne Six Bravo AL18 · S/N AL-351N44158Taylorcraft BC12-D · S/N 9958N44566Piper PA-28-151 · S/N 28-7415668N480XNJoseph Ivan Nalevanko TITAN TORNADO 1 · S/N T94503COHKO0118N5058CBellanca 7GCBC · S/N 1159-79N5140MTaylorcraft BC12-D · S/N 10440N535PBeech V35 · S/N D-8119N565RGDiamond Aircraft Ind DA 50 C · S/N 50.C.A.A.065N5999PPiper PA-24-250 · S/N 24-821N6144GCessna 150K · S/N 15071644N6601JPiper PA-28-180 · S/N 28-5061N7221JPiper PA-28-140 · S/N 28-24557N7549QCessna 421B · S/N 421B0341N760STPiper PA-46-701TP · S/N 46020076N7667GCessna 172L · S/N 17259367N8179XPiper PA-28-181 · S/N 28-8290109N831HCMark Coby EARLY BIRD JENNY · S/N 532N83856Aeronca 7AC · S/N 7AC-2537N84TDPiper PA-30 · S/N 30-1951N86321Aeronca 11AC · S/N 11AC-127N8780MBeech A23 · S/N M-564N9639DPiper PA-22-150 · S/N 22-6552N9914QCessna 172M · S/N 17265858
Back to Kernersville, NC