Ozark, AL

Cancelled registrations · 114

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

N6846QGrumman Acft ENG Cor-Schweizer G-164A · S/N 1722Cancelled Sep 12, 2012 · Registration pending, canceled · Built 1977N24722Cessna 152 · S/N 15280338Cancelled Sep 10, 2012 · Registration expired, pending cancellation · Built 1977 · Enterprise-Ozark Community CollegeN1198WBell 47G-4 · S/N 2952Cancelled Jul 24, 2012 · Registration expired, pending cancellation · Built 1965 · Williams BillN1038YHughes 269A · S/N 660583/64-18227Cancelled Jun 8, 2011 · Sale reported, canceled · Built 1966N405ASBell UH-1H · S/N 64-13629Cancelled Jan 11, 2011 · Exported to Yemen · Bell Aerospace Services IncN42321Bell UH-1H · S/N 7016289Cancelled Dec 28, 2010 · Exported to Yemen · Bell Aerospace Services IncN980ASBell UH-1H · S/N 6509663Cancelled Dec 28, 2010 · Exported to Yemen · Bell Aerospace Services IncN10HDBell TH-13T · S/N 67-17030Cancelled Oct 26, 2010 · Sale reported, pending cancellationN700UHBell/Southern Aero UH-1H · S/N 65-9703Cancelled Dec 3, 2008 · Triennial form not returned · Built 1965 · Unc Helicopter IncN25UHBell 212 · S/N 30818Cancelled Jul 29, 1999 · Exported to Spain · US Helicopter IncN22UHU S Helicopter UH-1H · S/N 7016299Cancelled Jul 9, 1998 · Exported to Spain · U S Helicopter IncN21UHU S Helicopter UH-1H · S/N 7321679Cancelled May 8, 1998 · Exported to SpainN16UHBell UH-1H · S/N 6815554Cancelled May 21, 1997 · Exported to Spain · US Helicopter IncN17UHBell UH-1H · S/N 6717762Cancelled May 16, 1997 · Exported to Spain · US Helicopter IncN19UHBell UH-1H · S/N 6600789Cancelled May 16, 1997 · Exported to Spain · US Helicopter IncN15UHBell UH-1H · S/N 6601097Cancelled May 15, 1997 · Exported to Spain · US Helicopter Inc.N9181FHughes 369HS · S/N 340571SCancelled Jul 15, 1996 · Exported to Australia · Tropic Helicopters IncN11UHBell UH-1H · S/N 7015871Cancelled Jun 27, 1996 · Exported to Spain · US Helicopter IncN205UDBell UH-1H · S/N 6600915Cancelled Jun 27, 1995 · Exported to Spain · Unc Helicopter IncN205UEBell UH-1H · S/N 6616606Cancelled Jun 27, 1995 · Exported to Spain · Unc Helicopter IncN82814Bell UH-1H · S/N 6601156Cancelled Jun 27, 1995 · Exported to Spain · Unc Helicopter IncN8281BBell UH-1H · S/N 6600837Cancelled Jun 27, 1995 · Exported to Spain · Unc Helicopter IncN6190PBell UH-1H · S/N 6616027Cancelled Jun 26, 1995 · Exported to SpainN6204DBell UH-1E · S/N 154757Cancelled Jun 1, 1995 · Exported to United Kingdom · Unc HelicopterN1026SHughes TH-55 · S/N 6418156Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Aviation & Tech CollegeN213Camair 480 · S/N 1057Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Aviation & Tech CollegeN3126BBeech E50 · S/N 563718Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Aviation & Technical CollegeN3126GBeech E50 · S/N 573097Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Aviation & Technical CollegeN49235Dehavilland DHC-2 · S/N 211Cancelled Apr 12, 1995 · Alabama Institute Of Avn TechnologyN5579AHughes TH-55 · S/N 6418220Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Aviation & Tech CollegeN5579KHughes TH-55 · S/N 6618338Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Aviation And Tech CollegeN6NFLearjet 25 · S/N 021Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Avn & Tech Coll FoundationN800NEAero Commander 560-A · S/N 267Cancelled Apr 12, 1995 · Alabama Aviation & Technical CollegeN87765Bell UH-1B · S/N 622096Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Avn And Technical CollegeN8894HNorth American NAVION · S/N NAV4894Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Institute Of Avn TechnologyN9049JHughes 269A · S/N 6418033Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Aviation & Tech CollegeN9049KHughes TH-55 · S/N 6410868Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Avn & Technical CollegeN9189RBeech C18S · S/N 6808Cancelled Apr 12, 1995 · Alabama Institute Of Aviation TechnologyN95576Bell TH-13T · S/N 6717034Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Avn Technical CollegeN95577Bell TH-13T · S/N 6717084Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Aviation & Technical CollegeN95578Bell TH-13T · S/N 6717123Cancelled Apr 12, 1995 · Triennial form not returned · Alabama Avn Technical CollegeN39SBStockwell/Booth SB-1 · S/N 851Cancelled Mar 1, 1995 · Triennial form not returned · Stockwell Clarence CN6020ZPiper PA-25 · S/N 2524Cancelled Jul 13, 1994N9032HSwearingen SA26-T · S/N T267Cancelled Feb 3, 1993N205TEBell 205A-1 · S/N 30292Cancelled Apr 22, 1991 · Exported to Italy · Southern Aero CorporationN6055ZPiper PA-25 · S/N 2562Cancelled Dec 26, 1990 · Triennial form not returned · Alabama Aviation & Technical CollegeN64675Cessna O-2A · S/N 6811013Cancelled Dec 26, 1990 · Triennial form not returned · Alabama Avn & Technical CollegeN2303VDehavilland CARIBOU DHC-4A · S/N 107Cancelled Mar 13, 1987 · Exported to Canada · Southern Helicopters IncN709WAHiller UH-23-C · S/N IA-HH-68-01Cancelled Jul 17, 1984 · Wilco AviationN2271VAgusta Bell AB205 · S/N 4090Cancelled Feb 8, 1980 · Exported to Singapore · Built 1969 · Southern Helicopters Inc
Back to Ozark, AL