Huntsville, AL

Cancelled registrations · 227

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

N242AMoon O E / Cavalaris J G LANCAIR · S/N 010Cancelled Nov 14, 2008 · Second triennial mailing, no response · Built 1991 · Moon Orman EN2467XCessna T206H · S/N T20608155Cancelled Oct 28, 2008 · Triennial form not returned · Built 2000 · N2467x LLCN12TATremblay Kathleen DRIFTER SB · S/N 1034SBCancelled Sep 17, 2007 · Triennial form not returned · Built 1997 · Bragg Philip CN81GHCessna T210N · S/N 21064355Cancelled Aug 24, 2006 · Exported to Mexico · Built 1981 · R&S Aviation SalesN496DDDunaway Dennis Gaines JR MINI MAX 1600 · S/N 0001Cancelled Oct 6, 2005 · Triennial form not returned · Built 1997 · Dunaway Dennis G JrN6408CTerkeurst Jr/Gardner/Sharp JR MU582 DRIFTER · S/N LL1043Cancelled Apr 25, 2005 · Triennial form not returned · Built 1999 · Sharp Thomas A JrN8KDBergmann Gary RANS S-12XL · S/N 05950597Cancelled Apr 25, 2005 · Built 1995 · Gardner Wayne CN22CQAerospatiale SA365N · S/N 6061Cancelled Nov 16, 2004 · Exported to Australia · Built 1983 · Health Care AuthN769LWBeech A36 · S/N E1028Cancelled Mar 5, 2001 · Triennial form not returned · Camp Associates LLCN71089Balloon Works FIREFLY 7 · S/N F7-397Cancelled Dec 8, 1999 · Triennial form not returned · Pinson V LN110WFFitzpatrick Wesley F KB-2 GYROPLANE · S/N KB-2-WF-1Cancelled Feb 17, 1999 · Triennial form not returned · Anderson Rodney DN391WNorth American T-28B · S/N 138266Cancelled Feb 12, 1998 · Exported to Switzerland · Barrow Thomas LN2142SCessna T210L · S/N 21061103Cancelled Jan 12, 1998 · Triennial form not returned · Green David EN1455JRockwell International 112A · S/N 455Cancelled Aug 1, 1996 · Triennial form not returned · Whitus AlbertN5112PPiper PA-24 · S/N 24124Cancelled May 8, 1995 · Triennial form not returned · Akins Robert DN4720JBeech A23-19 · S/N MB178Cancelled Feb 8, 1994 · Triennial form not returned · Daniel Phillip RN13738Cessna 172M · S/N 17262984Cancelled Oct 28, 1993 · Patterson Charles CN3929HEngineering & Research ERCOUPE 415-CD · S/N 4630Cancelled Sep 24, 1992 · Triennial form not returned · Yancey Edgar CN3742YCessna 210D · S/N 21058242Cancelled Mar 11, 1992 · Triennial form not returned · Beckman William HlN757DNCessna 152 · S/N 15279658Cancelled Nov 23, 1984 · Ritch Ernest RN9388KStinson 108-2 · S/N 108-2388Cancelled Jul 11, 1984 · Administratively canceled · Wall O RayN46791Canadair F-86 MK.5 · S/N 1129Cancelled Jun 22, 1983 · Sale reportedN70726Canadair F-86E MK.6 · S/N 1081Cancelled Jun 22, 1983 · Sale reportedN92426Canadair F-86E MK.6 · S/N 925Cancelled Jun 20, 1983 · Administratively canceledN201XCanadair F-86 MK.5 · S/N 993Cancelled Jun 1, 1983 · Sale reported · Built 1954N2290RCanadair F-86E MK.6 · S/N 1017Cancelled Jun 1, 1983 · Sale reported, pending cancellation · Built 1954N2290ZCanadair F-86E MK.6 · S/N 1073Cancelled Jun 1, 1983 · Sale reportedN98270Canadair F-86E MK.6 · S/N 1142Cancelled Jun 1, 1983 · Sale reported · Built 1954N99605Canadair F-86E MK.6 · S/N 818Cancelled Jun 1, 1983 · Sale reported · Built 1953N8948KUniversal Stinson 108-1 · S/N 1081948Cancelled Oct 2, 1982 · Administratively canceled · Schumaker Robert JN205HLBellanca 8KCAB · S/N 422-78Cancelled Sep 10, 1982 · Built 1978 · Lee Howard FN42799Piper J3C-65 · S/N 15114Cancelled Jun 3, 1982 · Built 1945 · Smith Donald EN5925JCessna 182P · S/N 18263580Cancelled Apr 9, 1982 · Exported to Canada · Caneer Ralph A JrN22626Cessna 150H · S/N 15068410Cancelled Mar 26, 1982 · Built 1968 · Wilson Homer B JrN3546HErcoupe 415-C · S/N 4171Cancelled Dec 23, 1981 · Hall Bobby JN72491Canadair F-86 MK.5 · S/N 937Cancelled May 23, 1979 · Sale reportedN3314GHamilton T-28R-2 · S/N 2Cancelled May 6, 1978 · Revoked, pending cancellation · Built 1951 · Coates Lloyd RN47324Taylorcraft DCO-65 · S/N 5163Cancelled Oct 15, 1976 · Bankowski Victor CN3639RPiper PA-28-180 · S/N 28-5734Cancelled May 8, 1975 · Connell Bell & Ellis IncN5901WPiper PA-28-160 · S/N 28-2966Cancelled May 8, 1975 · Huntsville Tower Flying Club IncN3881KTemco GC-1B · S/N 3581Cancelled Apr 4, 1975 · Built 1948 · Hardy BobN51184Fairchild M-62A · S/N T43-5624Cancelled Oct 25, 1974 · Built 1943 · Leatham William LN3860BBeech F35 · S/N D-4127Cancelled Sep 18, 1974 · Wilkerson DonN6477QMooney M20F · S/N 680019Cancelled Aug 16, 1974 · Moiseez MaxN3762SCessna 172E · S/N 17250962Cancelled Jul 31, 1974 · Atkinson R F L R Coates R A EverittN4109VCessna 170 · S/N 18441Cancelled Jul 31, 1974 · Built 1948 · Quarles John DN2PLLeeper BD-5 · S/N 1604Cancelled Jul 18, 1974 · Leeper Paul B JrN15218Piper PA-28-235 · S/N 28-7310023Cancelled May 16, 1974 · Built 1972 · Huntsville Aviation CorporationN8261XCessna 172C · S/N 17248761Cancelled Apr 24, 1974 · Williamson Robert H JrN9281JPiper PA-28-180 · S/N 28-3361Cancelled Apr 24, 1974 · Johnston Truman W
Back to Huntsville, AL