Skip to content

Cancelled registrations · 29

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

N44KXKeefer Thomas N MONI TRI-GEAR · S/N 334TCancelled Sep 25, 2023 · Sale reported, canceled N7433MCessna 175 · S/N 55733Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1959 · Graves Jackie D N27695Taylorcraft BL-65 · S/N 2337Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Built 1939 · Cone John M N95799Taylorcraft BC12-D · S/N 8099Cancelled Jul 10, 2020 · Revoked, canceled · Built 1946 · Carrell Homer E N130JJWilliams Willie C ZODIAC 601 XL · S/N 64639Cancelled Jan 23, 2020 · Exported to Bolivia · Brantly James K N894RGDJI PHANTOM 3 PROFESSION · S/N P76DCF25013776Cancelled Jan 6, 2020 · Registration expired, pending cancellation · Skysight Uav LLC N1711HCessna 310C · S/N 35811Cancelled Oct 28, 2017 · Revoked, canceled · Built 1959 · Southern Home Contractors Inc N53257Cessna 177RG · S/N 177RG1363Cancelled Sep 12, 2016 · Registration expired, pending cancellation · Built 1978 · Van Lengen Albert N49964Boeing A75N1 · S/N 75-351Cancelled Oct 28, 2014 · Exported to France · Built 1956 · Ratliff James G N447MSQuicksilver GT-400 · S/N 752Cancelled Jan 27, 2014 · Built 1987 · Isburgh Andrew N N83JHHickey John S SWEARINGEN SX300 · S/N 83Cancelled Sep 30, 2013 · Registration expired, pending cancellation · Built 1991 · J. Vincent Lyons Jr N9267DPiper PA-18 · S/N 18-6566Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1958 · Etheredge Cecil D N4126YBellanca 7GCBC · S/N 950-76Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1976 · Gudger Joseph W N2188CCessna 195B · S/N 16173Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1956 · Moulson Gary L N999SSGrumman American Avn. AA-1B · S/N AA1B-0097Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1972 · Whittington Betty Jean N9791XCessna 210C · S/N 21058091Cancelled Aug 6, 2012 · Registration pending, canceled · Built 1962 N18KSRaven S55A · S/N S55A-206Cancelled Jul 30, 2012 · Sale reported, canceled · Built 1974 N893Ashman Eric KITFOX CLASSIC IV · S/N C96120180Cancelled Nov 12, 2009 · Exported to Spain · Built 2003 · Ashman Eric N447ALLong Moody Allen TEAM 1600 · S/N AL-781Cancelled Aug 8, 2000 · Triennial form not returned · Isburgh Andrew N N50515Cessna 172M · S/N 17264207Cancelled May 18, 2000 · Exported to Canada · Deal Jack B N5399PCessna 152 · S/N 15284937Cancelled Feb 26, 1998 · Triennial form not returned · American East Airways Inc N67318Cessna 152 · S/N 15281749Cancelled Mar 24, 1997 · Allison Jeffrey K N8933MBeech 95-B55 (T42A) · S/N TC556Cancelled Aug 29, 1995 · Brown Grant M N67772Cessna 152 · S/N 15282010Cancelled Oct 13, 1994 · Triennial form not returned · American East Airways Inc N3466QCessna 320E · S/N 320E0066Cancelled Aug 5, 1993 · Triennial form not returned · Phoenix Refirgeration Systems Inc N4460NWordeman James A SWALLOW B · S/N 6820272XCCancelled Apr 17, 1991 · Triennial form not returned · Swallows Of Atlanta Inc N12667Cessna 172M · S/N 17262160Cancelled Jun 15, 1984 · Administratively canceled · Slater Huey R N800JBBeech 95-C55 · S/N TE-86Cancelled May 5, 1982 · Exported to Liberia · Allied Investment & Mortgage Co Inc N65942Consolidated Vultee BT-13A · S/N 5642Cancelled May 26, 1965 · Miller James C

Back to Conyers, GA