Durham, 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 = 'DURHAM' 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 = 'DURHAM' 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.
N100XXGrumman American Avn. AA-1B · S/N AA1B-0578N101CMooney M-18L · S/N 62N1044WBeech V35B · S/N D-9457N1072MDouglas DC3 · S/N 9832N118XSmith Winston R PITTS S1S · S/N RS-1N11971Cessna 150L · S/N 15075749Registration pendingN131BUBucker Jungmann C.A.S.A. 1.131 · S/N E3B-448N145DUEurocopter Deutschland MBB-BK 117 C-2 · S/N 9421N1474NPiper J3C-65 · S/N 23140N14BUAir Res Aviation SP Z O O T-131 JUNGMANN · S/N PA 204N1508TPiper PA-28R-200 · S/N 28R-7235308N1695GChampion 7KCAB · S/N 141N1699TPiper PA-28-140 · S/N 28-7125016N16PRaytheon 58 · S/N TH-1925N18KTextron 525B · S/N 525B0689N214HTVans RV-9A · S/N 93308N215TGWatson William P RV-10 · S/N 001N220HPPeck Harold W BARRACUDA · S/N 461N23612Beech F33A · S/N CE-756N237RDGracely Richard H RV-6 · S/N 20494N244STGrumman American Avn. AA-5A · S/N AA5A-0138N2515CCessna 170B · S/N 26159N2543NCessna 140 · S/N 12799N25DGCubcrafters CC11-160 · S/N CC11-00272N2681WMooney M20C · S/N 3319N272ZZDouglas DC3 · S/N 25509(43-48248)N281MFCirrus Design SR22 · S/N 10441N2HMManvel Harry Bancroft DEFIANT · S/N 146N2LEBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1312N30MCessna 525 · S/N 525-0506N310BGCessna 310R · S/N 310R0889N310SVCessna 310Q · S/N 310Q0509N325MAMitsubishi MU-2B-26 · S/N 325N329DSDiamond Aircraft Ind DA 40 · S/N 40.1142N3345FCessna 182J · S/N 18257345N351GMCompagnie Daher TBM 700 · S/N 1566Registration pendingN3542GLuscombe 8F · S/N S-74N3840KBoeing E75N1 · S/N 75-8399N39010Grumman American Avn. AA-1C · S/N AA1C0183N3986VCameron Balloons V-56 · S/N 5699N400KXCessna T182T · S/N T18208212N4105Mooney M-18LA · S/N 139N429GBoeing A75 · S/N 75-3174N44800Piper PA-28-180 · S/N 28-7505012N4518QGulfstream American AA-5B · S/N AA5B1044N485SVDiamond Aircraft Ind DA 42 NG · S/N 42.N387N4HYCirrus Design SR22T · S/N 11362N5399TPiper PA-28R-200 · S/N 28R-7235231N5413TCessna 172E · S/N 17251313N55718Boeing A75N1(PT17) · S/N 75-4619
Back to Durham, NC