OpenAirDocs.org
Gadsden, AL

Cancelled registrations · 51

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 = 'AL' AND d.registrant_city = 'GADSDEN'
  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.

N771JPExtra Flugzeugbau EA 300/L · S/N 054Cancelled Jun 4, 2024 · Built 1997 · Bellew Philip HN12042Flaglor CHEROKEE II · S/N 2Cancelled Oct 21, 2023 · Revoked, canceled · Built 1964 · Gatto Robert JN7558CForney F-1 · S/N 5675Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Built 1959 · Bailey Anna CN3101Termite BR-44 · S/N L-13Cancelled Nov 22, 2019 · Revoked, canceled · Built 1968 · Ridgway Alvis BarneyN98BWCessna 421C · S/N 421C0609Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1979 · Continental Air LLCN1271XMooney M20E · S/N 144Cancelled Feb 8, 2018 · Registration expired, pending cancellation · Built 1963 · Richards Motors IncN7231TAero Vodochody L-39 · S/N 630632Cancelled Jan 23, 2018 · Registration expired, pending cancellation · International Jets IncN7231UAero Vodochody L-39 · S/N 530545Cancelled Jan 23, 2018 · Registration expired, pending cancellation · International Jets IncN327JWsk-Pzl-Mielec TS-11 ISKRA · S/N 1H0327Cancelled May 8, 2015 · Registration expired, pending cancellation · International Jets IncN529JWsk-Pzl-Mielec TS-11 ISKRA · S/N 1H0529Cancelled May 6, 2015 · Registration expired, pending cancellation · International Jets IncN2591CPiper PA-38-112 · S/N 38-79A0248Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1978 · Alpine Air Service IncN220JWsk-Pzl-Mielec TS-11 ISKRA · S/N 1H0220Cancelled Sep 3, 2014 · Registration expired, pending cancellation · International Jets IncN8098TAero Vodochody L39C · S/N 430219Cancelled Aug 16, 2013 · Sale reported, canceled · Built 1974N202XXAero Vodochody L-39ZA · S/N 633913Cancelled Aug 15, 2013 · Exported to Czech Republic · Built 1986 · International Jets IncN63271Cessna 150M · S/N 15077220Cancelled Aug 5, 2013 · Revoked, canceled · Built 1975 · Corporate Jet Aviation IncN36RHHood Lewis R QUICKIE · S/N QAC-0075-RH1Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1981 · Anderson Fred H JrN732ZAero Commander 560 · S/N 204Cancelled May 7, 2013 · Registration expired, pending cancellation · Built 1955 · Davis Reno LN168TPiper PA-18 105 · S/N 18-2282Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1953 · Roden Frank EN4886ZPiper PA-22-108 · S/N 22-8468Cancelled Dec 7, 2012 · Sale reported, canceled · Built 1961N23991Aero Vodochody L39C · S/N 031628Cancelled Oct 9, 2012 · Registration expired, pending cancellation · International Jets L39 Parts & Maintenance IncN377DCDiamond Aircraft Ind DA20-C1 · S/N C0377Cancelled Sep 20, 2012 · Exported to Canada · Built 2006 · Kessler Catherine LauraN158ASBeech 95-C55 · S/N TE-51Cancelled Aug 8, 2012 · Registration expired, pending cancellation · Built 1966 · P And S Aviation IncN4336QCessna 172L · S/N 17260236Cancelled Sep 27, 2005 · Triennial form not returned · Built 1971 · Bald Eagle Aviation IncN40397Piper PA-23-250 · S/N 27-7305161Cancelled Jun 11, 2002 · Exported to Bahamas · Built 1973 · International Jets IncN6098RCessna 172G · S/N 17253767Cancelled Oct 7, 1996 · Triennial form not returned · Aviation Services Of Gadsden IncN6148RCessna T210F · S/N T2100048Cancelled Jan 31, 1991 · Triennial form not returned · Marshall Richard BN6587RBeech B19 · S/N MB-732Cancelled Apr 8, 1983 · Reagan Billy RipN3651GErickson James E JE-1 MITE SMALL · S/N JE-1Cancelled Jul 10, 1982 · Built 1962 · Golightly Ralph WN7873WPiper PA-28-180 · S/N 28-1896Cancelled Mar 4, 1981 · Aero Club Of Gadsden Ala IncN8302BCessna 172 · S/N 36102Cancelled Oct 7, 1980 · Aero Club Of Gadsden Alabama IncN4731APiper PA-18A 150 · S/N 18-4956Cancelled Dec 1, 1977 · Built 1956 · Coosa Flying Service IncN3953WPiper PA-32-260 · S/N 32-902Cancelled May 16, 1972 · American Air Service IncN4404MPiper PA-12 · S/N 12-3354Cancelled May 8, 1972 · Built 1947 · Noojin Joseph D/ Noojin Automatic Transmission SerN5515GCessna 150J · S/N 15071015Cancelled Apr 27, 1972 · Ingram Aircraft Service IncN3308JCessna 150G · S/N 15066008Cancelled Jan 17, 1972 · Built 1966 · Ingram Aircraft Service IncN2169RCessna 182G · S/N 18255369Cancelled Dec 20, 1971 · Ingram Aircraft Service IncN1493YCessna 172C · S/N 17249193Cancelled Dec 14, 1971 · Ingram Aircraft Service IncN2212Sauls Wiley Edward SAULS METEOR M-2 · S/N 1913Cancelled Dec 11, 1971 · Sauls Wiley EdwardN5034WPiper PA-28 · S/N 28-36Cancelled Oct 19, 1970 · Built 1961 · Curl Edsel VN2634KLuscombe 8E · S/N 5361Cancelled Jun 25, 1970 · Luscombe Club IncN70411Piper J3C-65 · S/N 17404Cancelled May 20, 1965 · Mears J UN5449CCessna 170A · S/N 19483Cancelled Jul 5, 1956 · Exported to Germany · Wilson B FN55529Consolidated Vultee BT-13A · S/N 3341Cancelled Dec 1, 1955 · Page Earnest SN9221EAeronca 11AC · S/N 11AC-855Cancelled Nov 14, 1955 · Built 1946 · Glasscock R JN38261Piper J3L-65 · S/N 6886Cancelled Apr 17, 1951 · Graham C LN24599Piper J3L-65 · S/N 3288Cancelled Apr 13, 1951 · C L GrahamN92042Piper J3C-65 · S/N 16475Cancelled May 10, 1949 · Atlantic Air IncN41288Piper J3L-65 · S/N 7930Cancelled Sep 29, 1948 · Built 1941 · Graham C LN17919Taylor J-2 · S/N 1519Cancelled Apr 27, 1948 · Barron W T & Eugene LivingstonN52393Cessna T-50 · S/N 2733Cancelled Feb 10, 1948 · Built 1943 · Atlantic Air Inc
Back to Gadsden, AL