Lawrenceville, GA
Registered aircraft · 100
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 = 'GA' AND g.registrant_city = 'LAWRENCEVILLE' 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 = 'GA' AND g.registrant_city = 'LAWRENCEVILLE' 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.
N115JRSocata TB 10 · S/N 937N116RWDassault-Breguet MYSTERE FALCON 900 · S/N 058N118AMWalsh James C SONEX TD · S/N 0148N120DTSikorsky S-76B · S/N 760362N125QLearjet 45 · S/N 027N12872Cessna 172M · S/N 17262331N152GTCessna 152 · S/N 15279503N1605KMD Helicopters 369FF · S/N 0604FFN166ACBeech 76 · S/N ME263N1808MD Helicopters 369FF · S/N 0318FFN2139TPiper PA-28R-200 · S/N 28R-7135145N229WFFlowers W Wayne SONEX · S/N 229N23675Cessna 172R · S/N 17280651N248GTCessna 172P · S/N 17274572N24DZRolfes Harry SEAREY · S/N 1DK068N26757Gulfstream American AA-5A · S/N AA5A0695N291GCDJI MAVIC 2 PRO · S/N 163CH8LR0A3D4MN2974TPiper PA-28-181 · S/N 28-8090024N298BCBeech 76 · S/N ME-59N3563APiper PA-22 · S/N 22-1837N373RBEmbraer EMB-135 · S/N 14500957N3839LBeech 76 · S/N ME-397N40494Cameron Balloons US A-105 · S/N 6489N41522Piper PA-28-151 · S/N 28-7415249N430GMooney M20R · S/N 29-0263N43654Piper PA-28-181 · S/N 28-8490086N448CCLearjet 45 · S/N 215N4518TPiper PA-32-260 · S/N 32-7200022N452MPLearjet 45 · S/N 152N45MWLearjet 45 · S/N 115N469BAIcon A5 · S/N 00089N482PTYarborough Victor A ZODIAC 601 XL · S/N 6-5293N50691Cessna 150J · S/N 15069487N50FGDassault MYSTERE-FALCON 50 · S/N 187N51582Cessna 172P · S/N 17274324First renewal noticeN52248Cessna 172P · S/N 17274458N5229SPiper PA-32-300 · S/N 32-40933N5258DAerostar International S-60A · S/N S60A-3258N5258EBalony Kubicek Spol Sro BB22Z · S/N 1907N525RCCessna 525 · S/N 525-0178N53507Cessna 172P · S/N 17274769N5355FCessna 172R · S/N 17281166N54180Cessna 172P · S/N 17274908N54203Cessna 172P · S/N 17274915N54291Cessna 172P · S/N 17274949N54457Piper PA-28-140 · S/N 28-7425138N54GRCanadair CL-600 CHALLENGER · S/N 3001N5514LCessna 152 · S/N 15284327N55404Cessna 172P · S/N 17275175N56JPLearjet 45 · S/N 183
Back to Lawrenceville, GA