Montgomery, AL

Cancelled registrations · 201

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

N993RHPiper PA-31T · S/N 31T-7720066Cancelled May 26, 2010 · Exported to Germany · Built 1977 · Bcs Group LLCN3312VBeech 35 · S/N D-771Cancelled Apr 26, 2010 · Registration revoked · Built 1947 · Rickert Donald NN103HABoeing 737-242 · S/N 21186Cancelled Apr 1, 2010 · Exported to Nicaragua · Built 1971 · Csi Holdings LLCN8188FSmith Wylie Jay KIT FOX II · S/N 378Cancelled Dec 18, 2008 · Triennial form not returned · Built 1996 · Tew Stanley MN98GFPiper PA-31T1 · S/N 31T-8004009Cancelled Sep 16, 2008 · Mtw Aerospace IncN218ASEmbraer EMB-120ER · S/N 120.015Cancelled Jul 18, 2008 · Built 1986 · Mtw Aerospace IncN21SAHawker Siddeley HS 125 600B · S/N 256006Cancelled Jan 17, 2008 · Sale reported · Built 1973N46JKBeech A100 · S/N B-154Cancelled Oct 25, 2007 · Exported to Canada · Built 1973 · White Skies Aviation LLCN3490LCessna 500 · S/N 500-0128Cancelled Sep 5, 2007 · Sale reportedN151ASCessna 500 · S/N 500-0183Cancelled Aug 24, 2007 · Triennial form not returned · Mtw Aerospace IncN238ASEmbraer EMB-120RT · S/N 120.053Cancelled Aug 24, 2007 · Triennial form not returned · Built 1987 · Mtw Aerospace IncN345DFPiper PA-31T · S/N 31T-7820088Cancelled Aug 24, 2007 · Built 1978 · Mtw Aerospace IncN77VJLearjet 23 · S/N 23-041Cancelled May 19, 2007 · Triennial form not returned · Built 1965 · Mtw Aerospace IncN36HJLearjet 35A · S/N 427Cancelled Mar 28, 2007 · Built 1981 · Mtw Aerospace IncN264CAEmbraer EMB-120RT · S/N 120.256Cancelled Oct 5, 2006 · Built 1992 · Mtw Aerospace IncN31168Fairchild SA227-AC · S/N AC-599Cancelled Jun 1, 2006 · Triennial form not returned · Mtw Aerospace IncN94840Ercoupe E · S/N 4913Cancelled Apr 19, 2006 · Triennial form not returned · Built 1948 · Probst Lloyd JN4392WBeech A100 · S/N B-192Cancelled Apr 6, 2006 · Triennial form not returned · Built 1974 · Mtw Aerospace IncN196CFLearjet 24B · S/N 186Cancelled Feb 21, 2006 · Triennial form not returned · Built 1969 · Mtw Aerospace IncN915USLearjet 24B · S/N 24-189Cancelled Feb 21, 2006 · Triennial form not returned · Built 1976 · Mtw Aerospace IncN229EMBeech C-12C · S/N 77-22948Cancelled Feb 3, 2006 · Triennial form not returned · Mtw Aerospace IncN95ACSwearingen SA226-T(B) · S/N T-381Cancelled Dec 16, 2005 · Built 1980 · Mtw Aerospace IncN66MFPiper PA-42-720 · S/N 42-5501009Cancelled Oct 26, 2005 · Triennial form not returned · Built 1983 · Mtw Aerospace IncN740EJGates Lear Jet 24B · S/N 222Cancelled Jul 19, 2005 · Triennial form not returned · Built 1970 · Mtw Aerospace IncN120AXEmbraer EMB-120ER · S/N 120.164Cancelled May 12, 2005 · Triennial form not returned · Built 1989 · Mtw Aerospace IncN28CKLearjet 25 · S/N 045Cancelled Apr 7, 2005 · Triennial form not returned · Mtw Aerospace IncN263ASEmbraer EMB-120RT · S/N 120.157Cancelled Mar 23, 2005 · Built 1989 · Mtw Aerospace IncN3034BLearjet 24 · S/N 176Cancelled Jan 31, 2005 · Triennial form not returned · Mtw Aerospace IncN234UMCessna 500 · S/N 500-0105Cancelled Nov 23, 2004 · Triennial form not returned · Built 1973 · Mtw Aerospace IncN5230DCessna 172N · S/N 17272460Cancelled Oct 6, 2004 · Triennial form not returned · Built 1979 · Civil Air Patrol IncN125HFHawker Siddeley HS-125-600A · S/N 256064Cancelled Aug 9, 2004 · Exported to Mexico · Built 1977 · Henig Aviation LLCN158AGHawker Siddeley DH.125-3A/RA · S/N 25155Cancelled Sep 4, 2003 · Sale reported · Built 1967N911ASHawker Siddeley DH.125-1A · S/N 25039Cancelled Sep 4, 2003 · Sale reported · Built 1965N912ASHawker Siddeley DH-125 · S/N 25124Cancelled Sep 4, 2003 · Sale reported · Built 1967N75609Chesnutt Glenn RAF 2000 · S/N H2-97-8-286Cancelled Jul 15, 2003 · Triennial form not returned · Built 1998 · Chesnutt Robert GN6356NCessna 182R · S/N 18267828Cancelled Jul 27, 2002 · Triennial form not returned · Built 1981 · Civil Air Patrol IncN9713TPiper PA-38-112 · S/N 38-78A0165Cancelled Sep 13, 2001 · Triennial form not returned · Montgomery Aviation CorporationN9458HCessna 182R · S/N 18267953Cancelled Jun 1, 2000 · Triennial form not returned · Civil Air Patrol IncN2619VCessna 177RG · S/N 177RG0633Cancelled Sep 29, 1999 · Dyna-Lift IncN8563SAir Tractor AT-301 · S/N 3010146Cancelled Aug 29, 1997 · Triennial form not returned · Davco Aviation IncN160SABell OH-58A · S/N 7015286Cancelled Oct 16, 1996 · State Of AlabamaN17KJCessna 210K · S/N 21059362Cancelled Mar 10, 1995 · Exported to Mexico · Wansley James JrN130RReak/Hale QUICKEI 2 · S/N 2578Cancelled Jul 27, 1994 · Triennial form not returned · Reak Oscar JN34CAMichael Donald R WIZARD T-38 · S/N 0029Cancelled Jul 19, 1994 · Triennial form not returned · Michael Larry WN85TWHughes TH-55 · S/N 6716702Cancelled Jun 16, 1993 · Triennial form not returned · Alabama Department Of Public SafetyN1737HCessna 310C · S/N 35837Cancelled Jun 11, 1991 · Triennial form not returned · Cundiff H LynnN100RNPiper PA-31T · S/N 31T7820091Cancelled Apr 26, 1991 · Triennial form not returned · Norment Industries IncN7054CHughes TH-55 · S/N 6716869Cancelled Apr 8, 1991 · State Of Alabama Abc BoardN45356E W Hodge HODGE # 1 · S/N 0001Cancelled Mar 19, 1991 · Triennial form not returned · E W Hodge & Co IncN8790MBeech A23 · S/N M-574Cancelled Mar 29, 1982 · Parker Builders
Back to Montgomery, AL