Cary, 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 = 'CARY' 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 = 'CARY' 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.
N1005AFantasy Air Sro ALLEGRO 2000 · S/N 05-039N11409Cessna 150L · S/N 15075398N1147DMooney M20K · S/N 25-0594N11VCVincent James S VANS RV6A · S/N 22306N12147Cessna 172M · S/N 17261842N123NCBell 206A · S/N 610N1305BCessna 172S · S/N 172S10654N1349DCessna 170A · S/N 19925N1452EAeronca 7AC · S/N 7AC-5015N161RFDJI INSPIRE 1 · S/N W13DEB17061655N1653AMaule MXT-7-180 · S/N 14121CN178RHCessna 680 · S/N 680-0178N181FAPiper PA-28-181 · S/N 288390062N190XBFaust Mark H RV-10 · S/N 41467N20025Cessna 172M · S/N 17260941N204SGDiamond Aircraft Ind DA 40 · S/N 40.482N226PADiamond Aircraft Ind DA 40 · S/N 40.1087N227MPCirrus Design SR22 · S/N 4141N231FKMooney M20K · S/N 25-0219N2325QBeech 23 · S/N M-389N236FBAlon A2 · S/N A-158N2377UPiper PA-28-161 · S/N 28-8016021N258RFDJI MAVIC PRO · S/N 08QUE4K001085EN27MKMaine Robert B AVID MK IV · S/N 1173DN280ASPiper PA-32R-300 · S/N 32R7780155N309CDCirrus Design SR22 · S/N 1104N311DPSchleicher ASW-20C · S/N 20831N3122EPiper PA-28-181 · S/N 2843250N3172DBeech A36 · S/N E-2454N3227QPiper PA-32R-300 · S/N 32R-7780299N33720Piper PA-28R-200 · S/N 28R-7535182N33JPitts S1-C · S/N JF-1N3672CCessna R182 · S/N R18200303N371EMBodette Edward/Crowder Michael JUST ACFT HIGHLANDER · S/N JA371-04-14N39PRBeech 95-C55 · S/N TE-23N401NCBell Textron Canada 429 · S/N 57457N404NCBell 407 · S/N 53788N405NCBell Helicopter Textron Canada 407 · S/N 53814N406NCBell Textron Canada 407 · S/N 56335N407NCBell Helicopter Textron Canada 407 · S/N 53840N4224RPiper PA-32-300 · S/N 32-40589N432WWPiper PA-28-181 · S/N 28-8390009N4337GNelson Sydney/Nelson Diann ZODIACXL · S/N 6391N438JDJames F Dolezal AIRCAM · S/N AC163N444CVCirrus Design SR22 · S/N 4527N511XSchempp-Hirth STANDARD CIRRUS · S/N 36N51YMSchaal Rand B J-250 LSA KIT · S/N 231N544CDCirrus Design SR22 · S/N 1544N572BPBeech F33A · S/N CE-1019N5759JCessna 182P · S/N 18263522
Back to Cary, NC