Statesville, NC
Registered aircraft · 81
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 = 'STATESVILLE' 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 = 'STATESVILLE' 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.
N100UJDornier Luftfahrt 328-300 · S/N 3118N13753Cessna 172M · S/N 17262994N13REEicher Robert L HATZ CB1 · S/N 1N1471CPiper PA-18A · S/N 18-2673N1527EFirefly Balloons FIREFLY 8B-15 · S/N F8B-2037N15VAEmbraer EMB-145LR · S/N 145072N187LBLindstrand Balloons 60X · S/N 5319N191JRBeech E-90 · S/N LW144N1952NScott Larry J KITFOX MODEL 4 · S/N 1560Sale reportedN21DEBeech 200 · S/N BB-117N21FDBeech C23 · S/N M-1621N2252NHead Balloons AX8-88 · S/N 338N2293UWilliams Myron Pell WILLIAMS MP-1 · S/N CH20795R1370N24LLHead Balloons AX7-77 · S/N 118N2553KBalloon Works FIREFLY 7-15 · S/N F7-793N25VAEmbraer EMB-145LR · S/N 145131N2656VCessna 170 · S/N 18166N2705QCessna 182K · S/N 18257905N273CMMaupin Clay C THATCHER CX4 · S/N 002N273RBFirefly Balloons FIREFLY 8B-15 · S/N F8B-2109N2789LCessna 172H · S/N 17255989N284WKDJI AGRAS T40 · S/N 1581F574B226D00100NYN2MBCessna 310R · S/N 310R1357N3007CEckert Charles E CUBY SPORT TRAINER · S/N 844N315HNesmith COUGAR · S/N 3575N325PLMooney M20C · S/N 3441N327HBPsota Frank J HIPERBIPE SNS-7 · S/N 221N335JBAmerican Legend AL11 · S/N AL-1088N337JBEmbraer ERJ 190-100 IGW · S/N 19000473N339JBEmbraer ERJ 190-100 IGW · S/N 19000490N35467Cessna 172I · S/N 17256785N355CLSaab SAAB 340B · S/N 340B-355Registration pendingN3651GBalloon Works FIREFLY 7 · S/N F7-043N368JHead Balloons AX7-70R · S/N 499N3728LCessna 172G · S/N 17253897N4077XWitte Earl KITFOX 4-1200 · S/N JCU-104Sale reportedN4202CFirefly Balloons 2010 FIREFLY 7-15 · S/N F7-2076N43VAEmbraer EMB-145LR · S/N 145061N46642Cessna 172K · S/N 17257405N46VAEmbraer EMB-145LR · S/N 145103N47VAEmbraer EMB-145 · S/N 145110N485CBCessna 421C · S/N 421C0466N49VAEmbraer EMB-145LR · S/N 145.151N5001CHead Balloons AX8-105 · S/N 498N5206Gregg Brozo SONEX A · S/N 0663N5347SGalaxy Balloons GALAXY 8 · S/N GLX-1038N5350LPiper PA-28-180 · S/N 28-4653First renewal noticeN55JHHickman Jeff L WHOPPER 1 · S/N 1-W-1N57447Bellanca 7GCAA · S/N 263-73N581UHDJI AGRAS T50 · S/N 63YBMB40020092
Back to Statesville, NC