OpenAirDocs.org
Abbeville, LA

Cancelled registrations · 29

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

N7741BAmerican Legend AL3 · S/N AL1125Cancelled Jun 23, 2021 · Exported to Australia · Built 2008 · Broussard Danny PN1332MBoeing E75N1 · S/N 75-8669Cancelled Aug 5, 2019 · Revoked, canceled · Built 1943 · Teal AlvinN60EABell 206B · S/N 2068Cancelled Jun 28, 2019 · Sale reported, canceled · Built 1976N54FCQuicksilver SPORT 2S · S/N SPORT 2S 0038Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 2008 · Campbell Fred JrN33493Piper J3C-65 · S/N 6002Cancelled Oct 28, 2017 · Revoked, canceled · Built 1940 · Teal AlvinN5322NCessna 182Q · S/N 18267645Cancelled May 10, 2017 · Built 1980 · Omega Protein CorporationN6519VCessna 172RG · S/N 172RG0746Cancelled Jan 18, 2017 · Registration expired · Built 1980 · Omega Protein IncN2250TCessna R182 · S/N R18200006Cancelled Dec 6, 2016 · Built 1977 · Omega Protein CorpN737WMCessna R182 · S/N R18200890Cancelled Mar 18, 2016 · Built 1979 · Omega Protein IncN114RDGarlick Helicopters OH-58A+ · S/N 70-15256Cancelled Aug 10, 2015 · Exported to Dominican Republic · Built 1970 · T & M Aviation IncN1651SSnow Commander 600-S2R · S/N 6001208CCancelled Dec 22, 2014 · Revoked, canceled · Built 1964 · Broussard & Teal Flg Svc IncN2113ZBell 206B · S/N 4067Cancelled Aug 22, 2013 · Sale reported, canceled · Built 1989N7150BPiper PA-22-150 · S/N 22-4374Cancelled Aug 20, 2013 · Registration expired, pending cancellation · Built 1956 · Skipton Donald EN2726WCourville Chester A KB 2 · S/N A32181Cancelled Mar 26, 2013 · Sale reported, canceledN49915Cessna 152 · S/N 15281391Cancelled Mar 18, 2013 · Registration expired, pending cancellation · Built 1978 · Vector Aviation IncN9728Grumman Acft ENG Cor-Schweizer G-164A · S/N 1246Cancelled Oct 30, 2012 · Third renewal notice · Built 1974 · Abbeville Air Service IncN9748Grumman Acft ENG Cor-Schweizer G-164A · S/N 1249Cancelled Oct 30, 2012 · Third renewal notice · Built 1974 · Abbeville Air Service IncN37834Morel Richard J QUICKSILVER MX II · S/N 4655Cancelled Aug 7, 2012 · Registration pending, canceled · Built 1983N131EHMesserschmitt-Boelkow-Blohm BO-105S · S/N S-595Cancelled Mar 22, 2012 · Sale reported · Built 1982N8613HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1434Cancelled Jul 9, 1997 · Triennial form not returned · Victory Flyers IncN48592Grumman Acft ENG Cor-Schweizer G-164B · S/N 74BCancelled Mar 28, 1991 · Triennial form not returned · Harrington Roland JN8066TCessna 175A · S/N 56766Cancelled Mar 10, 1975 · Segura Huey FN38LLLockheed P-38L · S/N 350281Cancelled Jan 8, 1975 · Built 1946 · Coastal Chemical CoN65353Boeing N2S-3 · S/N 75-6695Cancelled Apr 1, 1971 · Built 1946 · Chris Crusta Flying Service IncN5317NBoeing E75 · S/N 75-6003Cancelled Feb 5, 1971 · Victory Flyers IncN54590Boeing A75N1 · S/N 75-992Cancelled Jan 4, 1971 · Chris Crusta Flying Service IncN55111Boeing A75L3 · S/N 75-1866Cancelled Jan 4, 1971 · Chris Crusta Flying Service IncN6412TCessna 150 · S/N 17812Cancelled Jun 26, 1970 · James Noel Flying Service IncN69716Cessna T-50 · S/N 4515Cancelled May 22, 1965 · Broussard L J
Back to Abbeville, LA