Lafayette, LA

Cancelled registrations · 540

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

N486PHBell Helicopter Textron Canada 412EP · S/N 36601Cancelled Jan 10, 2018 · Built 2012 · Phi IncN746PBSikorsky S-76C · S/N 760623Cancelled Jan 9, 2018 · Exported to Israel · Built 2006 · Phi IncN779PDSikorsky S-76C · S/N 760655Cancelled Jan 5, 2018 · Exported to Israel · Built 2007 · Phi IncN211KFBins Tom KITFOX IV · S/N 1496Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Built 1993 · Johnson Donald GN32041Bell 206L-3 · S/N 51539Cancelled Dec 5, 2017 · Second renewal notice · Built 1991 · Phi IncN36ZAZenair CH 2000 · S/N 200036Cancelled Oct 27, 2017 · Registration expired, pending cancellation · Built 1997 · Kovacs Angela VN761PHSikorsky S-76A · S/N 760224Cancelled Aug 30, 2017 · Built 1981 · Phi IncN145PEAgustawestland Philadelphia AW139 · S/N 41271Cancelled Aug 17, 2017 · Exported to New Zealand · Built 2011 · Phi IncN763PSikorsky S-76A · S/N 760166Cancelled Aug 7, 2017 · Built 1981 · Phi IncN764PSikorsky S-76A · S/N 760276Cancelled Jul 31, 2017 · Built 1984 · Phi IncN762PSikorsky S-76A · S/N 760060Cancelled Jul 18, 2017 · Phi IncN1546KSikorsky S-76A · S/N 760082Cancelled Jul 17, 2017 · Built 1980 · Phi IncN1545KSikorsky S-76A · S/N 760047Cancelled Jul 14, 2017 · Built 1980 · Phi IncN480RABell Helicopter Textron 206L-1 · S/N 45401Cancelled Jul 7, 2017 · Registration expired, pending cancellation · Built 1980 · Ranger Aviation Parts LLCN369TSHawker Siddeley HS-125-600A · S/N 256069Cancelled Jun 14, 2017 · Registration expired, pending cancellation · Built 1977 · Ecl International IncN692RSikorsky S-92A · S/N 920028Cancelled Jun 6, 2017 · Exported to Australia · Built 2005 · Phi IncN30531Fawvor James Kim FLIGHTSTAR II SL · S/N 273Cancelled May 15, 2017 · Registration expired, pending cancellation · Built 2000 · Leboeuf Edward LN114EZCarter Ward VERIEZ · S/N N114EZCancelled Apr 18, 2017 · Registration expired, pending cancellation · Built 2001 · Carter Robert WN892HSikorsky S-92A · S/N 920038Cancelled Mar 29, 2017 · Exported to Australia · Built 2006 · Phi IncN3458KPiper PA-28-140 · S/N 28-23565Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Built 1967 · Leblanc Wayne CN792HSikorsky S-92A · S/N 920037Cancelled Mar 24, 2017 · Exported to Australia · Built 2006 · Phi IncN434WWBell 222 · S/N 47019Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Wordwide Helicopter Sales IncN923HSikorsky S-92A · S/N 920104Cancelled Mar 15, 2017 · Exported to Australia · Built 2009 · Phi IncN924RSikorsky S-92A · S/N 920116Cancelled Mar 10, 2017 · Exported to Australia · Built 2009 · Phi IncN206DDBell Helicopter Textron 206L-1 · S/N 45242Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1979 · D & P Central LLCN22347Bell 412 · S/N 36005Cancelled Feb 21, 2017 · First renewal notice · Built 1994 · Phi IncN1545XSikorsky S-76A · S/N 760050Cancelled Dec 7, 2016 · Phi IncN1546GSikorsky S-76A · S/N 760076Cancelled Dec 1, 2016 · Built 1980 · Phi IncN760PHSikorsky S-76A · S/N 760078Cancelled Nov 29, 2016 · Built 1980 · Phi IncN776PSikorsky S-76A · S/N 760275Cancelled Nov 23, 2016 · Built 1984 · Phi IncN229RHBell 206L-3 · S/N 51184Cancelled Sep 6, 2016 · Exported to South Africa · Built 1986 · Phi IncN209RHBell 206L-3 · S/N 51531Cancelled Sep 2, 2016 · Exported to South Africa · Built 1991 · Phi IncN10311Snyder & Owsley MONERAI-S · S/N 81Cancelled Aug 17, 2016 · Third renewal notice · Built 1980 · Liti IncN7897XBell 206-L4 · S/N 52297Cancelled Mar 2, 2016 · Exported to Canada · Built 2004 · Phi IncN416PHBell 407 · S/N 53276Cancelled Feb 26, 2016 · Built 1998 · Phi IncN484PHBell Helicopter Textron Canada 412EP · S/N 36599Cancelled Jan 4, 2016 · Exported to Saudi Arabia · Built 2012 · Phi IncN483PHBell Helicopter Textron Canada 412EP · S/N 36598Cancelled Oct 26, 2015 · Exported to Saudi Arabia · Built 2012 · Phi IncN485PHBell Helicopter Textron Canada 412EP · S/N 36600Cancelled Oct 26, 2015 · Exported to Saudi Arabia · Built 2012 · Phi IncN992RHSikorsky S-92A · S/N 920055Cancelled Aug 5, 2015 · Exported to Canada · Built 2007 · Phi IncN3982MCameron Balloons US V-90 · S/N 5668Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1990 · Ascenions Unlimited Balloon CoN13CSSimmons Chris S SONERAI II · S/N 1175Cancelled May 4, 2015 · Registration expired, pending cancellation · Simmons Chris SN6992Bell 222U · S/N 47521Cancelled Apr 21, 2015 · Phi IncN393AABell 230 · S/N 23028Cancelled Mar 24, 2015 · First renewal notice · Built 1994 · Phi IncN65734Boeing A75N1(PT17) · S/N 75-769Cancelled Nov 12, 2014 · Registration expired, pending cancellation · Built 1941 · Cherry Earl LN5814MCessna 310P · S/N 310P0114Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1969 · Young And AssociatesN4606HPiper PA-17 · S/N 17-22Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1948 · Martin Charles ChesterN8765JMesserschmitt-Bolkow-Blohm BK 117 A-4 · S/N 7054Cancelled Oct 3, 2014 · Exported to Israel · Built 1984 · Phi IncN27497Taylorcraft BC-65 · S/N 2139Cancelled Sep 25, 2014 · Registration expired, pending cancellation · Built 1940 · Dugan John JrN2008CBeech C23 · S/N M-2059Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1978 · Sharp Industries IncN266PBell 206-L4 · S/N 52271Cancelled Sep 5, 2014 · Built 2002 · Phi Inc
Back to Lafayette, LA