Skip to content

Lawrenceville, GA

Cancelled registrations · 80

Query with SQL

SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'GA' AND d.registrant_city = 'LAWRENCEVILLE' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_state = 'GA' AND d.registrant_city = 'LAWRENCEVILLE'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_state = 'GA' AND d.registrant_city = 'LAWRENCEVILLE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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.

N601ZMMehta Zersis ZENITH 601X ZODIAC · S/N 6-6389Cancelled Jan 17, 2024 · Built 2008 · Mehta Zersis M N402GJRaytheon 400A · S/N RK-380Cancelled May 13, 2023 · Plain Sense LLC N283TEDJI INSPIRE 1 · S/N W13DCD10030400Cancelled Dec 3, 2022 · Registration expired, pending cancellation · Third Eye Aerial Media LLC N689PCDJI INSPIRE 1 · S/N W21ACJ30010195Cancelled Dec 3, 2022 · Registration expired, pending cancellation · 12 Stone Church Inc N8643UDJI SPARK · S/N OASUFB600403SYCancelled Oct 1, 2022 · Registration expired, pending cancellation · Gwinnett County Police Department N864YGDJI SPARK · S/N 0ASUFB600403XHCancelled Oct 1, 2022 · Registration expired, pending cancellation · Gwinnett County Police Dept N8HQBeech 400 · S/N RJ-50Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Built 1988 · Mlw Lapaloma Inc N864XDDJI INSPIRE 2 · S/N 095XE16002013PCancelled Sep 3, 2022 · Registration expired, pending cancellation · Gwinnett County Police Dept N8671GDJI SPARK · S/N OASUFB600403XHCancelled Sep 3, 2022 · Registration expired, pending cancellation · Gwinett Country Police Department N635BSDJI MAVIC 2 PRO · S/N 163CJ7PR0A8ATPCancelled Aug 8, 2022 · Flying Rock LLC N30GCDJI INSPIRE 2 · S/N 095XE160020110Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Gwinnett County Police Dept N635WDDJI INSPIRE 1 · S/N W13DCG1004055Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Gwinnett County Police Dept N5927GPrioria Robotics MAVERIC · S/N M100-100155Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Gwinnett County Sheriffs Dept N30EFCessna 172P · S/N 17275849Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Built 1982 · Flight School Of Gwinnett N278JSAeroprakt America JABIRU SPECIAL J430 · S/N 301Cancelled Sep 26, 2020 · Sale reported, canceled · Built 2018 N24695Beech C23 · S/N M-1446Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 1973 · Jones Stephen A N780PGDJI PHANTOM 3 PROFESSION · S/N P78DCH25031720Cancelled May 2, 2020 · Registration expired, pending cancellation · Gwinnett County Police Dept N863GJRaytheon HAWKER 800XP · S/N 258663Cancelled Dec 12, 2019 · Exported to Russia · Built 2004 · Blue Horseshoe Enterprises LLC N687RRDJI PHANTOM 3 PROFESSION · S/N P76DCI07010828Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Full House Roofing Service Inc N4363FPiper PA-28R-200 · S/N 28R-7635406Cancelled Jul 25, 2019 · Registration expired, pending cancellation · Built 1976 · Flight School Of Gwinnett N54069Cessna 172P · S/N 17274867Cancelled Mar 9, 2019 · Registration expired, pending cancellation · Built 1981 · Flight School Of Gwinnett Inc N395MCCessna 310N · S/N 310N-0064Cancelled Jan 17, 2019 · Registration expired, pending cancellation · Built 1968 · N395mc LLC N737EQCessna 172N · S/N 17269364Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1977 · K B Skyway LLC N36WRPiper PA-23-250 · S/N 27-7304932Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Skywings LLC N622EZOuzts Rodney RUTAN-LONGEZ · S/N 656Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Built 2005 · Rowe David W N12EXKaas Dennis EXPRESS · S/N 12Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Rowe David W N45845Cameron Balloons N-105 · S/N 1919Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Duffy Martin Joseph N896SPPiper PA-18 · S/N 54-2377Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1954 · Dunagan Timothy Reed N246DRRank Richard C KITFOX III · S/N 1185Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1991 · Napier David M N739SACessna 172N · S/N 17270758Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1978 · Astron Enterprises Inc N3504SCondor CONDOR · S/N C-154Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 2003 · Adams Wesley M N700UFU-Fly-It Light Sport Acft SPORT 2S · S/N 0183Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 2007 · Roderigas Henry W N400GJBeech 400 · S/N RJ-23Cancelled Dec 2, 2013 · Built 1988 · Mlw La Paloma Inc N4902BBeech C-50 · S/N CH-298Cancelled Jul 10, 2013 · Sale reported, canceled · Built 1955 N5580AAndrews James J QUICKSILVER MX II · S/N 1838Cancelled Jun 13, 2013 · Registration expired, pending cancellation · Andrews James J N8481LCessna 337 · S/N 68-11149Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Georgia Historical Aviation Museum N55466Southern Air-Time CGS HAWK · S/N 078Cancelled Jun 4, 2013 · Registration expired, pending cancellation · Southern Air-Time Inc N220MSSchweizer 269C · S/N S1361Cancelled Apr 18, 2013 · Registration expired, pending cancellation · Built 1989 · Dooley Helicopters Inc N4693MPiper PA-11 · S/N 11-202Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1947 · Crowe W D N42728Piper J3C-65 · S/N 15026Cancelled Nov 21, 2012 · Registration expired, pending cancellation · Built 1945 · Dunagan Timothy Reed N1521FBalloon Works FIREFLY 7 · S/N 90002Cancelled Aug 6, 2012 · Registration expired, pending cancellation · Built 1981 · Schoeck Richard K N69619Cessna 310R · S/N 310R0104Cancelled Aug 6, 2012 · Second renewal notice · Built 1975 · Quest Diagnostics N1RZZahner-Robert VARIEZE · S/N 1400Cancelled May 3, 2012 · Registration expired, pending cancellation · Built 1981 · Zahner Robert A N857PMRobinson Helicopter R44 · S/N 1034Cancelled Dec 19, 2011 · Built 2001 · Forest Tech LLC N5756HBell Helicopter Textron 206L-1 · S/N 45541Cancelled Jul 20, 2011 · Expired dealer · Crescent Airways Inc N9513RCessna 172R · S/N 17280619Cancelled Jun 21, 2011 · Exported to Australia · Built 1998 · David Reese Construction Co N2099MPiper J3C-65 · S/N 20880Cancelled May 25, 2011 · Revoked, canceled · Built 1946 · Davis Dan N5998JCessna 172N · S/N 17273850Cancelled Apr 28, 2010 · Exported to Philippines · Built 1980 · Starnes Robert N737FZCessna 172N · S/N 17269395Cancelled Apr 28, 2010 · Exported to Philippines · Built 1977 · Starnes Robert N825MAPiper PA-23-250 · S/N 27-2037Cancelled Sep 8, 2009 · Triennial form not returned · Aviation Institute Of Maintenance

Back to Lawrenceville, GA