OpenAirDocs.org
Stockbridge, GA

Cancelled registrations · 30

Query with SQL
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 = 'STOCKBRIDGE'
  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.

N1470Piaggio P-149D · S/N 139Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1958 · Browning Gregory HN71648Luscombe 8A · S/N 3075Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Built 1946 · Harms Fred WN1664HPiper PA-32R-300 · S/N 32R-7780171Cancelled Aug 26, 2021 · Registration pendingN582BTGuided Systems Technologies IN V-10ET · S/N GST001Cancelled Sep 20, 2019 · Sale reported, canceledN697DMPiper PA-22-150 · S/N 227376Cancelled Mar 30, 2018 · Registration expired, pending cancellation · Built 1960 · Sloss John WN3590TPiper PA-32-260 · S/N 32-366Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1966 · Butler Michael DN7948FCessna 150F · S/N 15064048Cancelled Mar 7, 2017 · Built 1966 · Wood Jeremy EN145DSSenn Dale R SUPER BABY LAKES · S/N 9217-H-1140SBCancelled Oct 17, 2014 · Registration expired, pending cancellation · Built 1997 · Woodcock Richard HN6123WPiper PA-28-140 · S/N 28-20139Cancelled Aug 5, 2013 · Revoked, canceled · Built 1964 · Trumpolt Lewis EN5262KRyan NAVION B · S/N NAV-4-2162BCancelled Aug 27, 2012 · Registration pending, canceled · Built 1950N18654Fairchild 24R-9 · S/N R9-306Cancelled Aug 14, 2012 · Registration expired, pending cancellation · Built 1939 · Perkins Alfred SN55161Cessna 172P · S/N 17275124Cancelled Jul 6, 2005 · Exported to United Kingdom · Built 1981 · Davis Stephen RN82EKKind Erik N THORP T-18 · S/N 1-82Cancelled Dec 8, 2003 · Triennial form not returned · Built 1987 · Kind Erik NN53232Boeing D75N1 · S/N 75-3843Cancelled Dec 5, 2001 · Triennial form not returned · Built 1943 · St Julien James RN712DALockheed L-1011-385-1 · S/N 193C-1088Cancelled Jul 25, 2001 · Air Associates IncN787DLLockheed L-1011-385-1 · S/N 193A-1126Cancelled Jul 25, 2001 · Air Associates IncN716DALockheed L-1011-385-1 · S/N 193C-1095Cancelled Jul 24, 2001 · Air Associates IncN724DALockheed L-1011-385-1-15 · S/N 193C-1151Cancelled Jul 24, 2001 · Air Associates IncN725DALockheed L-1011-385-1 · S/N 193C-1162Cancelled Jul 24, 2001 · Air Associates IncN752DALockheed L-1011-385-3 · S/N 193W-1172Cancelled Jul 24, 2001 · Air Associates IncN783DLLockheed L-1011-385-1 · S/N 193A-1009Cancelled Jul 24, 2001 · Air Associates IncN789DLLockheed L-1011-385-1 · S/N 193A-1142Cancelled Jul 24, 2001 · Air Associates IncN9547FCameron Balloons US V-77 · S/N 5575Cancelled May 15, 1999 · Triennial form not returned · Fisher Stephen PaulN86734Bellanca 14-13 · S/N 1095Cancelled Sep 29, 1998 · Triennial form not returned · Joiner Derek AN4186JPiper PA-28-140 · S/N 2822525Cancelled Feb 13, 1998 · Triennial form not returned · Perry David EN98321Piper PA-28-140 · S/N 2826169Cancelled Jan 30, 1997 · Triennial form not returned · Hammonds John AN1538ZBalloon Works FIREFLY 7-B · S/N 10243Cancelled Mar 24, 1992 · Triennial form not returned · Fisher Steven PN2460PPiper PA-22-150 · S/N 22-2835Cancelled Nov 5, 1982 · Exported to Canada · Dorn Robert EN2678UCessna 172D · S/N 17250278Cancelled Apr 2, 1981 · Built 1963 · Perkins Alfred S SrN1751QCessna 150 · S/N 15073051Cancelled Oct 6, 1975 · Berry Hill Aviation Inc
Back to Stockbridge, GA