Charlotte, NC
Registered aircraft · 341
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 = 'CHARLOTTE' 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 = 'CHARLOTTE' 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.
N1016NCessna 182T · S/N 18281547N1041GMooney M20K · S/N 25-0567N10502Cirrus Design SR22 · S/N 10502N106AVDJI MATRICE 600 PRO · S/N EC031627453700N10MDassault FALCON 900EX · S/N 220N10XCCessna 172L · S/N 17260749N1116ARaytheon A36 · S/N E-3073N111JWCubcrafters CC11-160 · S/N CC11-00360N1143JAero Commander 112 · S/N 143N1147GMooney M20K · S/N 25-0595N114SERockwell International 114 · S/N 14027N116USCzech Sport PIPER SPORT · S/N P1001051N119BMMichael R Farley WAIEX · S/N 0056N11UUGlasflugel KESTREL · S/N 42N123VBAmerican General Acft AG5B · S/N 10056N1334XColumbia Aircraft Mfg LC42-550FG · S/N 42510N1377JRockwell International 112A · S/N 377N13TGTimothy J Goddard TEXAS SPORT TX-3 · S/N TX-1027N141DSean P Tucker SLING 4 TSI · S/N 377SKN142JSGulfstream Aerospace GVII-G500 · S/N 72003N143XBeech 35-33 · S/N CD-147N148VGrumman G1159B · S/N 54N149PBeech C23 · S/N M-2237N14BWCirrus Design SF50 · S/N 0547N1504XPiper PA-28R-200 · S/N 28R-7535301N1549HCirrus Design SR22 · S/N 4030N162AEEurocopter Deutschland EC 135 P2+ · S/N 1125N162LLLarry Dale Hale ROTORWAY EXEC 162F · S/N 2708N1646RGrumman American Avn. AA-1B · S/N AA1B0646N164KXCirrus Design SR22T · S/N 1064N165RCCessna 680 · S/N 680-0281N167AMMoscarelli Andrew RV6A · S/N 23163N1688Avia Stroitel AC-4C · S/N 049N169MCDJI INSPIRE 1 · S/N W13DCB14020352N172KPCessna 172K · S/N 17257218N178EPiper PA-30 · S/N 30-1727N184SJDJI MATRICE 30T · S/N 11581F5BK723C100BT044N185JJCessna A185E · S/N 185-1093N187DAero Vodochody L-39ZO · S/N 831121N191PGPilatus PC-12/47E · S/N 1775N192SAHawker Beechcraft HAWKER 900XP · S/N HA-0192N196AHPilatus PC-24 · S/N 196N198BDDavid William Joseph ONE DESIGN · S/N 96-0357N1CWPilatus PC-12/47E · S/N 1705N1KGJonker Sailplanes JS3 RES · S/N 03-178N1RHGulfstream Aerospace GVI (G650ER) · S/N 6470N1VMDassault FALCON 2000EX · S/N 240N20123Cessna 172M · S/N 17261027N2023North American SNJ-5 · S/N 84917N20265Head Balloons AX8-88 · S/N 459
Back to Charlotte, NC