Skip to content

Cancelled registrations · 57

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

N913JWAllen H Smith YOUNGSTER V · S/N YO.79Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Smith Allen H N87830Hartway PIETENPOL AIRCAMPER · S/N WDH1976Cancelled Jan 8, 2022 · Registration expired, pending cancellation · Built 1976 · Boatright Jeffrey H N8600HNorth American NAVION · S/N NAV-4-565Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Built 1947 · Estes Neil N343DGAerospatiale/Alenia ATR 42-320 · S/N 343Cancelled Oct 31, 2020 · Registration expired, pending cancellation · Dgi II LLC N285DGAtr-Gie Avions De Trnsp Rgnl ATR 42-300 · S/N 284Cancelled Dec 19, 2019 · First renewal notice · Dgi II LLC N367DGAerospatiale/Alenia ATR-42/300 · S/N 376Cancelled Dec 19, 2019 · Dgi II LLC N57333DJI PHANTOM 3 PROFESSION · S/N P76DCE26016130Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Peed Joseph D N607DGBoeing 737-247 · S/N 23607Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Dg I III LLC N3002XCessna 150F · S/N 15064402Cancelled Oct 17, 2018 · Built 1966 · Gas Publishing LLC N78236Globe GC-1B · S/N 2236Cancelled Oct 1, 2018 · Revoked, canceled · Built 1946 · Pozza Albin N3205EAeronca 11AC · S/N 11AC1550Cancelled Sep 27, 2018 · Revoked, canceled · Built 1946 · Powell John T N28975Bellanca 14-12F-3 · S/N 1045Cancelled Aug 9, 2018 · Revoked, canceled · Built 1941 · Barber William H N833ACBoeing 737-4S3 · S/N 25134Cancelled Apr 24, 2018 · Registration expired, pending cancellation · Dgi II LLC N89180Cessna 140 · S/N 8194Cancelled Mar 16, 2018 · Revoked, canceled · Built 1946 · Parris John N N51CQCarrison Dale W SIEMENS-SCHUCKERT D1 · S/N DALE CARRISON SSD1-001Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Built 1995 · Whitaker Wayne N2117WBeech C23 · S/N M-1490Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1973 · United Safety Apparatus Inc N3724JCessna 150G · S/N 15065024Cancelled Nov 18, 2017 · Revoked, canceled · Built 1966 · Allison Johnie DBA N3067SCessna 150G · S/N 15066967Cancelled Oct 28, 2017 · Revoked, canceled · Built 1967 · Glendale Flying Club Inc N1643FCessna 172H · S/N 17255038Cancelled Jul 20, 2017 · Registration expired, pending cancellation · Built 1966 · Rohrer Stephen B N741PLPeterson BUSHBY MUSTANG II · S/N 461Cancelled Feb 24, 2017 · Exported to Bolivia · Built 1975 · Butler Andrew J N88LRBeech 95-B55 (T42A) · S/N TC-593Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Garrard Lola S N606DGBoeing 737-247 · S/N 23606Cancelled Feb 1, 2017 · Dgi III LLC N335DGAerospatiale/Aeritalia ATR 42-300 · S/N 035Cancelled Sep 15, 2016 · First renewal notice · Dgi II LLC N6312WPiper PA-28-140 · S/N 28-20371Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1964 · Gonzales W M N878DGBoeing 737-2B7 · S/N 22878Cancelled Mar 2, 2015 · Dgi III LLC N6CKnight Twister Senior 125 · S/N 1Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1966 · Kennedy Gary D N26900Gulfstream American AA-5A · S/N AA5A0798Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1979 · Farmakis Tom S N66703Consolidated Vultee BT-13 · S/N 9310Cancelled Sep 26, 2013 · Revoked, canceled · Built 1943 · Jenkins C R N6005HBeech C24R · S/N MC-637Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1978 · Dekalb Mri Ct Vii Inc N919GBBeech C18S · S/N 8705Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1945 · Bankston Edward L N8295FCessna 150F · S/N 15064395Cancelled Aug 20, 2013 · Sale reported, canceled · Built 1966 N7040XCessna 150A · S/N 15059140Cancelled Jul 9, 2013 · Registration expired, pending cancellation · Built 1961 · Parris John N N2803QAerodifusion S L JODEL D-1190S · S/N 71Cancelled Jun 11, 2013 · Sale reported, canceled · Built 1963 N298DGAerospatiale/Aeritalia ATR 42-300 · S/N 0298Cancelled Jun 7, 2013 · Exported to Canada · Dau Global Leasing LLC N8755NPiper PA-28-140 · S/N 28-25575Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1969 · Harrison Clark DBA N6173ECessna 172 · S/N 46273Cancelled Apr 26, 2013 · Registration expired, pending cancellation · Built 1958 · Barnes Daniel M N60285Cessna 150J · S/N 15070196Cancelled Feb 26, 2013 · Revoked, canceled · Built 1969 · Martin James G N259DGBoeing 737-332 · S/N 25996Cancelled Feb 23, 2012 · Exported to Zambia · Dgi II LLC N294AAMcdonnell Douglas DC-9-82(MD-82) · S/N 49306Cancelled May 23, 2011 · Dgi I LLC N91DKEurocopter AS 350 B2 · S/N 3497Cancelled Nov 5, 2010 · Triennial form not returned · Dekalb County Police Services N5457TGlaser-Dirks Flugzeugbau DG-200 · S/N 2-57ACancelled Mar 5, 2002 · Built 1978 · Ruf Chris J N705JHHawker Siddeley HS.125 SERIES 700A · S/N NA0221Cancelled Mar 11, 1998 · Exported to Canada · John H Harland Company N106ESchleicher KA 6 E · S/N 4078Cancelled Jul 12, 1994 · Triennial form not returned · Mcgaughey David N456BCCessna 182J · S/N 18257174Cancelled May 29, 1975 · Built 1966 · Read Ronald C N7022NBeech 65-B80 · S/N LD-403Cancelled May 6, 1975 · Exported to Venezuela · Davidson Day Care Centers Inc N4524KNavion NAVION A · S/N NAV-4-1524Cancelled Apr 21, 1975 · Exported to Canada · Built 1949 · Taylor David B N7324Aero Commander 520 · S/N 520-94Cancelled May 10, 1974 · Poston Joe T N4336GMcculloch J-2 · S/N 046Cancelled Jul 5, 1973 · Wildwood Inc N79559Cessna 172K · S/N 17258174Cancelled Jun 25, 1973 · Garrett James L N2569VCessna 170 · S/N 18110Cancelled Mar 8, 1971 · Price Thomas J

Back to Decatur, GA