OpenAirDocs.org
Tallulah, LA

Cancelled registrations · 41

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 = 'LA' AND d.registrant_city = 'TALLULAH'
  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.

N50260Cessna 150H · S/N 15069173Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Moore Todd TN35208Piper J3C-65 · S/N 6206Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1941 · Gaumnitz FredN745ACAmerican Champion 8GCBC · S/N 387-97Cancelled May 1, 2020 · Registration expired, pending cancellation · Built 1997 · Buck Scout LLCN24610Piper J-3 · S/N 3295Cancelled Oct 18, 2019 · Revoked, canceled · Built 1939 · Grady H DN79595Fairchild M-62A · S/N T424310Cancelled Mar 2, 2019 · Revoked, pending cancellation · Built 1943 · Tidings Gerald LN946RWStarling Mark Daniel QUAD CITY CHLNGR II · S/N CH2-1201-2166Cancelled Feb 7, 2018 · Registration expired, pending cancellation · Built 2001 · Webb Robert C IIIN73623Boeing B75N1 · S/N 75-7644Cancelled Feb 4, 2017 · Revoked, canceled · Built 1943 · Sharpe A VN7854Grumman G-164A · S/N 802Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1971 · Farm Air Service IncN6749HBeech A36TC · S/N EA-132Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1980 · Olvey John WN6261HPiper J3C-65 · S/N 19432Cancelled Aug 5, 2013 · Revoked, canceled · Built 1946 · Grady BillyN9876Grumman Acft ENG Cor-Schweizer G-164A · S/N 1315Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1974 · Red Beard Dusting Service IncN7409Vickers VISCOUNT 797 · S/N 107Cancelled May 8, 2013 · Registration expired, pending cancellation · Built 1955 · Kivett RobertN5306Grumman G-164A · S/N 589Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 1969 · Farm Air Service IncN195WDouglas DC3C · S/N 20403Cancelled Feb 1, 2013 · Registration expired, pending cancellation · Built 1943 · Green Ag Aero IncN52850Boeing B75N1 · S/N 75-3598Cancelled Dec 18, 2012 · Sale reported, canceled · Built 1942N98GZSiddens Neil C ZIMMER SPORT · S/N 00198Cancelled Dec 11, 2012 · Sale reported, canceled · Built 1998N55799Boeing A75N1(PT17) · S/N 75-1831Cancelled Sep 24, 2012 · Sale reported, pending cancellation · Built 1941N65262Cessna T-50 · S/N 6068Cancelled Sep 5, 2012 · Revoked, canceled · Built 1944 · Scott Walter M JrN2645UTeer Terence T CHALLENGER II · S/N CH2-1200-2035Cancelled Jun 13, 2012 · Registration pending, canceled · Built 2002N1207MBoeing A75N1(PT17) · S/N 75-5233Cancelled Jun 4, 2012 · Sale reported, canceledN998WMMyers Winfred L RAF 2000 GTX · S/N H2-98-9-358Cancelled Mar 30, 2005 · Built 1998 · Sevier Conrad MN805SBell UH-1H · S/N 63-08805Cancelled Apr 2, 1999 · Exported to Australia · Twin City Aviation Center CorpN501TSHughes Helicopters 369E · S/N 0018ECancelled Apr 24, 1998 · Exported to SwedenN5458Grumman Acft ENG Cor-Schweizer G-164A · S/N 1162Cancelled Jan 2, 1997 · Exported to Philippines · Beard Gayle DBAN8375Grumman Acft ENG Cor-Schweizer G-164A · S/N 867Cancelled Jul 18, 1995 · Second triennial mailing, no response · Farm Air Service IncN355YGrumman G-164 · S/N 208Cancelled Feb 27, 1995 · Exported to Mexico · Beard Gayle DBAN7651ZPiper PA-25-235 · S/N 25-3792Cancelled Jun 19, 1985 · Exported to Mexico · Gustafson Merle BN4378CChampion 7EC · S/N 7EC-402Cancelled Sep 30, 1981 · Built 1956 · Gustafson MN42213Cessna 182L · S/N 18258904Cancelled Jan 25, 1977 · Built 1968 · Wells Milner And Seale John TN185PParsons B-8M · S/N CP-001Cancelled May 7, 1975 · Built 1963 · Gustafson Merle BN7465DPiper PA-18A 150 · S/N 18-5792Cancelled Aug 23, 1972 · Omega Flying Service Inc.N82401Aeronca 7AC · S/N 7AC-1034Cancelled Jul 15, 1971 · Brulte Thomas Adrel JrN55008Piper J3C-65 · S/N 8180Cancelled Aug 19, 1970 · Graves R NN59265Cessna T-50 · S/N 3179Cancelled May 20, 1965 · Merle B Gustafson & R C ToddN45968Luscombe 8A · S/N 2495Cancelled Mar 29, 1956 · Pryor R CN54151Piper J3C-65 · S/N 10425Cancelled Apr 1, 1955 · Yeates James MorganN5626Victory Aircraft Engineering C SS-1 · S/N 1Cancelled Jul 2, 1934 · Campbell R TN2034Waco 9 · S/N 222Cancelled Sep 26, 1929 · Built 1926 · Southern Dusting Co IncN3361U S Post Office Dept DH-4 · S/N UNKNOWNCancelled Nov 12, 1927 · U S Dept Of AgricultureN487Unknown UNKNOWN · S/N DA-3Cancellation date not recorded · U S Department Of AgricultureN90Curtiss Airplane Mfg JN-6 SE · S/N I-488Cancellation date not recorded · U S Dept Of Agriculture
Back to Tallulah, LA