Skip to content

Cancelled registrations · 111

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 = 'KENNESAW' 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 = 'KENNESAW'
  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 = 'KENNESAW'
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.

N2467QCessna 172S · S/N 172S10578Cancelled Apr 22, 2026 · Exported to Canada · Built 2007 · N2467q LLC N966TWMcdonnell Douglas DC-9-83(MD-83) · S/N 53616Cancelled Mar 26, 2026 · Exported to Mozambique · Built 1999 · Aic Jets Corp Trustee N9677WMcdonnell Douglas DC-9-83(MD-83) · S/N 53627Cancelled Mar 24, 2026 · Exported to Mozambique · Built 1999 · Aic Jets Corp Trustee N293PKSikorsky S-76B · S/N 760359Cancelled Mar 7, 2024 · Built 1989 · Spmk Helo LLC N22507Cessna 150H · S/N 15068324Cancelled Jan 13, 2024 · Sale reported, canceled · Built 1968 N623WAmerican AA-1 · S/N AA1-0137Cancelled Jul 22, 2023 · Sale reported, canceled · Built 1969 N46151Fk-Lightplanes SP Zo O SW51 · S/N 51-004Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Hansen Air Group Inc N501RGCessna 501 · S/N 501-0260Cancelled Feb 4, 2022 · Second renewal notice · Remonia Air LLC N904SPBell OH-58A · S/N 70-15564Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Georgia Department Of Public Safety N4385KPiper PA-46-310P · S/N 46-8508027Cancelled Jun 11, 2021 · Sale reported · Built 1984 N39ASAlbert J Simonich JR A 600T · S/N 193000Cancelled Apr 15, 2020 · Chow David N258MCGarlick Helicopters OH-58A+ · S/N 72-21258Cancelled Jul 16, 2019 · Registration expired, pending cancellation · Built 1972 · Georgia Dept Of Public Safety N453UArea-I SMB · S/N SMB001Cancelled Jan 16, 2019 · Registration expired, pending cancellation · Area I Inc N450UArea-I PTERA · S/N PTERA002Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Area-1 Inc N451UArea-I SBXC · S/N SBXC001Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Area-I Inc N454UArea-I SMB · S/N SMB002Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Area-I Inc N177LMCessna 177RG · S/N 177RG0937Cancelled Sep 13, 2018 · Sale reported, canceled N452UArea-I HAWK-I 2 · S/N HWK002Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Area -I Inc N2504ZBellanca 8KCAB · S/N 329-77Cancelled Jul 30, 2018 · Sale reported N76RDMaule M-5-180C · S/N 8034CCancelled May 31, 2018 · Sale reported, canceled · Built 1984 N602RRAir Tractor AT-602 · S/N 602-1197Cancelled May 30, 2018 · Sale reported, canceled · Built 2011 N6658RBeech V35B · S/N D-10323Cancelled May 22, 2018 · Sale reported, canceled · Built 1979 N4386FPiper PA-32R-300 · S/N 32R-7680446Cancelled Apr 30, 2018 · Sale reported, canceled · Built 1976 N7675QCessna 310Q · S/N 310Q0454Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Built 1972 · Nw Aviation Group LLC N8719HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1489Cancelled Mar 27, 2018 · Sale reported, pending cancellation · Built 1975 N97WJDassault/Sud FAN JET FALCON · S/N 101Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1967 · J P Aviation Inc N903SPBell OH-58A · S/N 69-16319Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Georgia Department Of Public Safety N915AJAir Tractor AT-802A · S/N 802A-0566Cancelled Feb 2, 2018 · Sale reported · Built 2014 N739PFCessna 172N · S/N 17270691Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1978 · Atlanta Northside Aviation Inc N23CECharles Harry L VARIEZE · S/N 1936Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1991 · Phillips Marlin K N926SPBell OH-58C · S/N 70-15512Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Georgia Department Of Public Safety N445VMNorma Stefanie Alba Mcguigan CHALLENGER II · S/N CH2-03082842Cancelled Oct 24, 2017 · Registration expired, pending cancellation · Mcguigan Norma S Alba N3509MPiper PA-28R-201 · S/N 28R-7837119Cancelled Feb 6, 2017 · Sale reported · Built 1978 N6545ECessna 182R · S/N 18268373Cancelled Sep 13, 2016 · Sale reported, canceled · Built 1984 N5275LPiper PA-28-180 · S/N 28-4574Cancelled Jun 7, 2016 · Sale reported · Built 1968 N98WJGulfstream Aerospace G-1159 · S/N 89Cancelled May 3, 2016 · Third renewal notice · Built 1970 · Southern Jet Management LLC N265QBeech 95-C55 · S/N TE-106Cancelled May 13, 2015 · Sale reported, canceled · Built 1966 N6593GHughes 300C · S/N 1201012Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1980 · Helicopter Connection Inc N8375GCessna 150F · S/N 15062475Cancelled Apr 8, 2015 · Sale reported · Built 1965 N58437Cessna 182P · S/N 18262061Cancelled Oct 7, 2014 · Sale reported · Built 1973 N6549WPiper PA-28-140 · S/N 28-20628Cancelled Sep 22, 2014 · Sale reported, canceled · Built 1965 N21306Cessna 182P · S/N 18261550Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1972 · Vx Realty Inc N3823LCessna 172G · S/N 17253992Cancelled Jul 3, 2014 · Sale reported · Built 1965 N61LNCessna 182D · S/N 18253398Cancelled Jul 3, 2014 · Sale reported · Built 1961 N4975SPiper PA-28R-200 · S/N 28R-35693Cancelled May 21, 2014 · Sale reported · Built 1970 N8308JCessna 150G · S/N 15066208Cancelled Sep 10, 2013 · Registration expired, pending cancellation · Built 1967 · A & S Aviation Inc N29MWBeech V35B · S/N D-10086Cancelled Aug 29, 2013 · Sale reported · Built 1977 N1404FCessna 172H · S/N 17254899Cancelled Aug 27, 2013 · Sale reported, canceled · Built 1967 N4473DBeech G35 · S/N D-4614Cancelled Aug 19, 2013 · Sale reported, canceled · Built 1956 N5301PCameron Balloons US C-80 · S/N 6143Cancelled Aug 19, 2013 · First renewal notice · Built 1997 · Scherm Peter J

Back to Kennesaw, GA